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

Published on 20-Nov-2018 06:44:11

• Related Questions & Answers
• Why does comparing types in MySQL won’t raise an error?
• How do I raise an http error/exception from a Python CGI script?
• How to raise an exception in Python?
• Resolve MySQL ERROR 1064 (42000): You have an error in your syntax?
• How do I manually throw/raise an exception in Python?
• How to change MySQL error message language?
• In MySQL, how to raise a number to the power of another number?
• PHP – How to raise an arbitrary precision number to another using bcpow() function?
• How to catch an assertion error in Java
• How MySQL evaluates if I will use an expression within SUM() function?
• Using backticks in CONTACT() gives an error in MySQL
• How to raise jQuery Events and handle them?
• How to find the raise to the power of all values in an R vector?
• 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?