mysql从5.7之后开始,支持json数据格式 创建表 create table json_user ( uid int auto_increment, data json, primary key(uid) ); 插入数据1 insert into json_user values( null, ' { "name":"lison", "age":"18", "address":"enjoy" } ' ); 插入数据2 insert into json_user values( null, ' { "name":"james", "age":"28", "address":"james@163.com" } ' ); 查询数据 select * from json_user; 获取[10,20,[30,40]] 中的第三个元素即[30,40] select json_extract('[10,20,[30,40]]','$[2]'); 查询json类型的data字段中的name和address两个值 select json_extract(data,'$.name'), json_extract(data,'$.address') from json_user; 将"name","ejoy","email","enjoy.com","age",35 转化为json对象并展示出来 select json_object ("name","ejoy","email","enjoy. |
mysql支持json数据格式
最新推荐文章于 2024-06-05 11:57:45 发布