Mysql5.7 JSON 数据存储

1.创建json 数据类型的字段

2.查询 JSON_EXTRACT

select JSON_EXTRACT(value,'$.name') from sys_setting

3.更新 JSON_SET

update sys_setting set value =  JSON_SET(value,'$.name','222333') where `key`='payment'

上一篇
下一篇