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 `k…