1-- 创建表
2CREATE TABLE json_test_table (
3    id INT PRIMARY KEY,
4    data JSON
5);
6--插入一条JSON数据
7INSERT INTO json_test_table (id, data) VALUES (1, '{"name": "John", "age": 30, "city": "New York"}');
8--查询数据
9SELECT * FROM json_test_table;