Syntax\n------\n\nSHOW LOCALES\n\nDescription\n-----------\n\nSHOW LOCALES was introduced as part of the Information Schema plugin extension.\n\nSHOW LOCALES is used to return locales information as part of the Locales plugin. It requires this plugin to be installed to work.\n\nWhile the information_schema.LOCALES table has 8 columns, the SHOW LOCALES statement will only display 4 of them:\n\nExamples\n--------\n\nSHOW LOCALES;\n+-----+-------+-------------------------------------+------------------------+\n| Id  | Name  | Description                         | Error_Message_Language |\n+-----+-------+-------------------------------------+------------------------+\n|   0 | en_US | English - United States             | english                |\n|   1 | en_GB | English - United Kingdom            | english                |\n|   2 | ja_JP | Japanese - Japan                    | japanese               |\n|   3 | sv_SE | Swedish - Sweden                    | swedish                |\n...\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-locales