数据库中对json的创建修改操作

数据库中对json的创建修改操作
创建数据库的表包含json的字段

create table tab_json(id int not null auto_increment primary key,data json);

insert into tab_json values (null,'{"name":"Mike","address":"Beijing","tel":13249872314}');

通过json_set函数,来修改data字段的值

update tab_json set data = json_set(data,"$.address","Guangzhou") where id = 1;  #对id = 1的行的address的键值进行修改.

update tab_json set data = json_set(data,"$.address","Shenzhen");

update tab_json set data = json_set(data,"$.address","Hangzhou") where id = 2; #对id为2的address键值进行修改

update tab_json set data = json_set(data,"$.passcode","654567") where id = 1;  #对id为1的passcode字段进行修改,发现没有这个键值,就增加了一个键值对.