appending json files for mysql

Question

This is more of a question in seeing if MySQL has any support for appending a JSON object without adding any extensions.

Say I have a JSON object that is in a person table in my MySQL server that contains the following:

    {"John":"male",
    "Jane":"female"}

and in any language that can execute MySQL code through their api wanted to add the following

    {"Jack":"male",
    "Jill":"female"}

to have the JSON object end up like this:

    {"John":"male",
    "Jane":"female",
    "Jack":"male",
    "Jill":"female"}

Would this be possible without grabbing the object and appending it within the code rather than executing a MySQL command. If it is possible, how would it be done?

I am currently using 10.3.22 of MariaDB.

Barmar · Accepted Answer · 2020-07-23 18:54:43Z

1

Use the JSON_MERGE_PATCH() to combine JSON objects.

UPDATE person 
SET json_col = JSON_MERGE_PATCH(json_col, '{"Jack":"male", "Jill":"female"}')
WHERE ...

answered Jul 23, 2020 at 18:54

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

1 Comment

Rick James Over a year ago

(That function and JSON_MERGE_PRESERVE are available as of 5.7.22 and 10.2.25.)

Collectives™ on Stack Overflow

appending json files for mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related