How to raise an error within MySQL?

MySQL has introduced signals similar to an exception in other languages. Let us first see the syntax of signal.

SIGNAL SQLSTATE ' PredefinedValueforSignalError' 
SET MESSAGE_TEXT = 'AnyMessageInformation';

Above, we have set our own error message text as well.

We will apply the above query to get an error message with the help of signals.

mysql > SIGNAL SQLSTATE '42927' SET MESSAGE_TEXT = 'Error Generated';

The following is the output of the above query.

ERROR 1644 (42927): Error Generated

In the above output, ‘42927’ is a SQLSTATE and ‘Error Generated’ is an error message, which we added.

Chandu yadav

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

• Related Questions & Answers
• Why does comparing types in MySQL won’t raise an error?
• How to raise an exception in Python?
• Resolve MySQL ERROR 1064 (42000): You have an error in your syntax?
• How to change MySQL error message language?
• How do I manually throw/raise an exception in Python?
• In MySQL, how to raise a number to the power of another number?
• How to catch an assertion error in Java
• Using backticks in CONTACT() gives an error in MySQL
• How MySQL evaluates if I will use an expression within SUM() function?
• PHP – How to raise an arbitrary precision number to another using bcpow() function?
• In MySQL, how to check for a pattern which is not present within an expression?
• How to send an error code using JSP to browser?
• How to find the raise to the power of all values in an R vector?
• How to use MongoDB $pull to delete documents within an Array?
• Fix MySQL Error #1064 - You have an error in your SQL syntax… near 'TYPE=MyISAM?