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 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}