为什么json的函数无法使用？
create table user ( uid int auto_increment, data json,primary key(uid))engine=innodb;
insert into user values (NULL, “{“name”:”David”,”mail”:”jiangchengyao@gmail.com”,”address”:”Shangahai”}”);
insert into user values (NULL,”{“name”:”Amy”,”mail”:”amy@gmail.com”}”);
select jsn_extract(data, “$.name”),jsn_extract(data,”$.address”) from user;
create table user ( uid int auto_increment, data json,primary key(uid))engine=innodb;
insert into user values (NULL, “{“name”:”David”,”mail”:”jiangchengyao@gmail.com”,”address”:”Shangahai”}”);
insert into user values (NULL,”{“name”:”Amy”,”mail”:”amy@gmail.com”}”);
select jsn_extract(data, “$.name”),jsn_extract(data,”$.address”) from user;
解决方案
20
json_extract 不是jsn
CodeBye 版权所有丨如未注明 , 均为原创丨本网站采用BY-NC-SA协议进行授权 , 转载请注明mysql 提示不存在 jsn_extract 函数！