1 of 1

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 .

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 , for example:

See for a full description.

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