mysql insert .对象,如何使用MySQL查询创建和插入JSON对象?

I'm trying to create a JSON object and then read the values from it into MySQL table. But I'm facing errors and I'm new to both JSON and MySQL.

SET @j = '{"key1": "value1", "key2": "value2"}';

CREATE TABLE Person (name int,id int);

INSERT INTO Person (name,id) SELECT * FROM OPENJSON(@j) WITH (name int,id int);

解决方案

On creating table set your field as JSON datatype.

CREATE TABLE `person` (

`name` json DEFAULT NULL

);

And Insert JSON data into it,

INSERT INTO `person` (`name`)

VALUES ('["name1", "name2", "name3"]');

Or Insert JSON data by Key:Value

INSERT INTO person VALUES ('{"pid": 101, "name": "name1"}');

INSERT INTO person VALUES ('{"pid": 102, "name": "name2"}');

Select JSON data,

SELECT * FROM `person` WHERE JSON_CONTAINS(name, '["name1"]');

Note: MySQL 5.7 InnoDB or higher version only supports.