How to add a value to a JSON Array in a MySQL Table

Question

I have a JSON typed column and I try to use the native JSON functions that MySQL allow me to use: https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html

I am especially looking for a way to update the JSON. Adding several values in the same JSON Array. The documentation is a bit rough on this point.

I know that it's not recommended to store JSON in a DB but I don't have the choice.

Thomas Jalabert · Accepted Answer · 2019-09-02 16:08:17Z

8

After a few minutes I managed to create my query:

UPDATE table 
SET field=JSON_ARRAY_INSERT(field, "$[0]", JSON_OBJECT('c', 0.5, 'd', 0.9)) 
WHERE id=12;

I'm sure I will forget this, so I created this page for my future self.

Good luck and Have fun!

answered Sep 2, 2019 at 16:08

Thomas Jalabert

1,47614 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1