I have two tables that are related to one another. For simplicity let’s define them as products and productVariants: I would like the functionality that whenever a row is inserted into productVariants, a new row is inserted into products with id equal to the childProductId field in productVariants. For example, say my products table has one row in it as
Tag: google-cloud-spanner
Is there a (key:value) pair datatype that can be used as a column in SQL – Specifically Google Cloud Spanner?
Given the scenario that I would like to store sales of a store in a table in a database in Google Cloud Spanner. That table would (in addition to the sale ID as the primary key) have to store a list of product IDs sold, along with the quantity of each product sold. Ideally, this would be in the form
how to update and append values to array in google spanner
I have a column with data type Array(String) in spanner. How can I append value to an array for update queries I’m able to update the values using this command But the problem with this update is it overrides the previous values. I want to append these values to the ones that are already present. Is there any command that