测试三条语句:
首先查看当前的mysql版本号:
select version();
1.
CREATE TABLE json_test(
id INT, person_desc TEXT )ENGINE INNODB;
2.
ALTER TABLE json_test MODIFY person_desc json;
3.
SELECT id,json_keys(person_desc) AS "keys" FROM json_test本文共 269 字,大约阅读时间需要 1 分钟。
测试三条语句:
首先查看当前的mysql版本号:
select version();
1.
CREATE TABLE json_test(
id INT, person_desc TEXT )ENGINE INNODB;
2.
ALTER TABLE json_test MODIFY person_desc json;
3.
SELECT id,json_keys(person_desc) AS "keys" FROM json_test转载于:https://www.cnblogs.com/tris/p/5391487.html