In this article, we would like to show you how to create table with
JSON field in MySQL.
CREATE TABLE `table_name` ( `column_name` JSON );
In this example, we create
objects table with
json column which will be
CREATE TABLE `objects` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `json` JSON, PRIMARY KEY (`id`) );
after we insert some values, we get the following result:
Go to this article to see how to insert
JSONtype values to the table.