EN
MySQL - Insert JSON type value to the table
0 points
In this article, we would like to show you how to insert JSON type value to the table in MySQL.
Quick solution:
xxxxxxxxxx1
INSERT INTO `table_name` (`column_name`)2
VALUES3
('{"key1": value1, "key2": value2, "key3": value3}'),4
('{"key4": value4, "key5": value5, "keyN": valueN}');
To show how to insert JSON type values to the table, we will use the objects table created in the previous article:
Example
In this example, we will insert into the objects table three new JSON values.
Query:
xxxxxxxxxx1
INSERT INTO `objects` (`json`)2
VALUES3
('{"height": 100, "width": 100, "color": "red"}'),4
('{"height": 200, "width": 200, "color": "green"}'),5
('{"height": 300, "width": 300, "color": "blue"}');Result:
