

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- 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?
Advertisements