How to raise an error within a MySQL function

mysql function exception stored-procedures
Dónal picture Dónal · Jan 21, 2009 · Viewed 87.2k times · Source

I've created a MySQL function and would like to raise an error if the values passed for the parameters are invalid. What are my options for raising an error within a MySQL function?

Answer

Austin Hyde picture Austin Hyde · Aug 6, 2012

MySQL 5.5 introduces signals, which are similar to exceptions in other languages:

http://dev.mysql.com/doc/refman/5.5/en/signal.html

For example, in the mysql command line client:

mysql> SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Custom error';
ERROR 1644 (45000): Custom error

Related questions

Deprecated: mysql_connect()

I am getting this warning, but the program still runs correctly. The MySQL code is showing me a message in PHP: Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO …

Read More
How do I get SUM function in MySQL to return '0' if no values are found?

Say I have a simple function in MySQL: SELECT SUM(Column_1) FROM Table WHERE Column_2 = 'Test' If no entries in Column_2 contain the text 'Test' then this function returns NULL, while I would like it to return 0. I'm aware that …

Read More
Mysql function returning a value from a query

i want to create a function which calculates a value using a query and I am having a problem returning the value: Shortened, my query is: CREATE FUNCTION func01(value1 INT , monto DECIMAL (10,2)) RETURNS DECIMAL(10,2) BEGIN SET @var_name = 0; select @…

Read More