Skip to content
Advertisement

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

update CarTable set models = ["BMW","HONDA"] WHERE year = "2020"

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 takes care of this requirement?

Advertisement

Answer

You can use the ARRAY_CONCAT function for that:

update CarTable set models = ARRAY_CONCAT(models, ["BMW","HONDA"]) WHERE year = "2020"
User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement