docker安装
docker pull mysql:5.7
运行docker
docker run --name mysql -p 3306:3306 -e MYSQL\_ROOT\_PASSWORD=123456 -d mysql:5.7
进入容器修改MySQL允许远程连接
docker exec -it mysql bash
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
测试MySQL5.7新特性json,首先创建表
CREATE TABLE `user` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`info` json DEFAULT NULL, #注意desc字段类型为json
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
插入数据
INSERT INTO
user(
uid,
info) VALUES (1,'{\"mail\": \"jiangchengyao@gmail.com\", \"name\": \"David\", \"address\": \"Shangahai\"}'),(2,'{\"mail\": \"amy@gmail.com\", \"name\": \"Amy\"}');
查询数据
SELECT uid,json_extract(info,'$.mail') AS 'mail',json_extract(info,'$.name') AS 'name' FROM USER;
> 其中 json_extract
是MySQL的内置函数第一个参数是表的字段,第二个参数是json对象里面的字段