Description\n-----------\n\nThe TYPE_MYSQL_JSON plugin is available from MariaDB 10.5.7.\n\nThe 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:\n\n``sql\nSELECT * FROM mysql_json_table;\nERROR 4161 (HY000): Unknown data type: 'MYSQL_JSON'\n`\n\nThe mysql_json plugin is used to make it easier to upgrade to MariaDB.\n\nInstalling\n\nInstalling can be done in a number of ways, for example:\n\n`sql\nINSTALL SONAME 'type_mysql_json';\n``\n\nSee Making MariaDB understand MySQL JSON for a full description.\n\nURL: https://mariadb.com/docs/server/reference/plugins/other-plugins/mysql_json