Mysql 之Json类型

mysql 中 json 类型体验

insert 插入一条json数据user

INSERT INTO test(user) VALUES ('{"name":"张三","age":20,"sex":"男","child":[{"name":"张老大","age":5,"sex":"男"},{"name":"张小花","age":2,"sex":"女"}]}');

select 查找

SELECT user FROM test ;

输出结果

{"age": 20, "sex": "男", "name": "张三", "child": [{"age": 5, "sex": "男", "name": "张老大"}, {"age": 2, "sex": "女", "name": "张小花"}]}

select 查找 支持jsonPath语法

###查找user.child[0].name
SELECT

user->"$.child[0].name" as 'tag'

FROM test;

输出结果：

"张老大"