How to change MySQL error message language?

You can use lc_messages to change MySQL error message language. The syntax is as follows −

SET lc_messages = 'yourLanguage';

To understand the concept, let us create a table with some error and check the error message language.

Here, we have set the local message to French. Let us first create a table −

mysql> create table errorMessagelanguage
   -> (
   -> Error_MessageId int,
   -> Error_Message varchar(100),
   -> );

The error message is as follows −

ERROR 1064 (42000): Erreur de syntaxe près de ')' à la ligne 5

Now you can set the error message to be in English language. The query is as follows −

mysql> set lc_messages ='en_US';
Query OK, 0 rows affected (0.00 sec)

Now create a table with some error and check the error message language −

mysql> create table errorMessagelanguage
   -> (
   -> Error_MessageId int,
   -> Error_Message varchar(100),
   -> );

Here is the output −

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5

karthikeya Boyini

Updated on 30-Jul-2019 22:30:25

• Related Questions & Answers
• comp_err - Compile MySQL Error Message File
• JavaScript Error message Property
• How to create a Tkinter error message box?
• How to change app language when user selects language in Android?
• How do I print a message to the error console using JavaScript?
• Getting error message while using SAP Scripting Tool
• How to change the app language programmatically in android?
• How I can change alert message text color using JavaScript?
• How can I verify Error Message on a webpage using Selenium Webdriver?
• How to change MySQL timezone?
• Getting error message: Scalar type not allowed in SAP HANA
• How to raise an error within MySQL?
• How to change the language of an app when the user selects language using Kotlin?
• How can we write MySQL handler, in a stored procedure, that throws an error message and continues the execution?
• How can we write MySQL handler, in a stored procedure, that throws an error message and exit the execution?