D

Dmitry Bolshakov2019-09-01 18:00:48

MySQL

Dmitry Bolshakov, 2019-09-01 18:00:48

UPDATE ... JSON MySQL?

Let's say the table is `table`, the column is called `qwerty`, the content is on one of the rows

{
"name" : 0,
"name1" : 1,
"name2" : 2
}

How do I query to update `table`, set `name1 = 2` in `qwerty` column?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

L

Lazy @BojackHorseman MySQL, 2019-09-01
@Flappy1488

Partial update of JSON values