mysql5.7 json支持多大

mysql5.7 json支持多大

mysql5.7 json支持多大
在mysql 5.7中，可以支持json了，比如一个表：
mysql> create table my_hash (id int not null primary key, doc json);
Query OK, 0 rows affected (0.59 sec)

mysql> show tables;
+------------------+
| Tables_in_test |
+------------------+
| my_hash_0 |
| my_hash_1 |
| my_hash_2 |
| my_hash_3 |
| pre_forum_post_6 |
| pre_forum_post_7 |
| t_json |
+------------------+
7 rows in set (0.00 sec)

插入一些记录
mysql> insert into my_hash (id, doc)
-> values (1, '{"key1": "row1_1", "key2": "row1_2"}');
Query OK, 1 row affected (0.02 sec)

mysql> insert into my_hash (id, doc)
-> values (2, '{"key1": "row2_1", "key2": "row2_2"}');
Query OK, 1 row affected (0.02 sec)

mysql> insert into my_hash (id, doc)
-> values (3, '{"key1": "row3_1", "key2": "row3_2"}');
Query OK, 1 row affected (0.02 sec)

mysql> insert into my_hash (id, doc)
-> values (4, '{"key1": "row4_1", "key2": "row4_2"}');
Query OK, 1 row affected (0.02 sec)

下面开始使用json
mysql> select doc->"$.key1" from my_hash where id =2;
+---------------+
| doc->"$.key1" |
+---------------+
| "row2_1" |
+---------------+
1 row in set (0.00 sec)

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息