## 概述 5.7版本提供了对json格式的支持,type类型就是json. ## 创建表 ``` create table json_test( id int unsigned auto_increment primary key, info json not null ); ``` ## 插入数据 ``` insert into json_test VALUES (null,'{"name":"jack","age":20,"gender":"male","height":180}'); ``` ## 查看数据 ``` +----+--------------------------------------------------------------+ | id | info | +----+--------------------------------------------------------------+ | 1 | {"age": 20, "name": "jack", "gender": "male", "height": 180} | +----+--------------------------------------------------------------+ ``` 具体使用网上搜吧.