测试三条语句:
首先查看当前的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
测试三条语句:
首先查看当前的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