mysql 插入json数据
http://www.shsnc.com/show-109-1004-1.html
1 创建表
mysql>create table t ( id int, data json, primary key(id)) engine=innodb; Query OK, 0 rows affected (0.01 sec)
1
2 添加数据
mysql>insert into t values (1,'{"type":"fruit","name":"apple"}'); Query OK, 1 row affected (0.00 sec)
3
select * from t;