MYSQL_JSON

The MYSQL_JSON plugin provides a JSON data type alias for compatibility, ensuring that tables created with the MySQL JSON type can be read by MariaDB.

The TYPE_MYSQL_JSON plugin is available from MariaDB 10.5.7.

The JSON type in MySQL stores the JSON object in its own native form, while, in MariaDB, the JSON type is a LONGTEXT. Opening a table with a JSON type created in MySQL results in an error:

SELECT * FROM mysql_json_table;
ERROR 4161 (HY000): Unknown data type: 'MYSQL_JSON'

The mysql_json plugin is used to make it easier to upgrade to MariaDB.

Installing

Installing can be done in a number of ways, for example:

INSTALL SONAME 'type_mysql_json';

See Making MariaDB understand MySQL JSON for a full description.

_{This page is licensed: CC BY-SA / Gnu FDL}