Revision: 70286
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at January 3, 2016 20:43 by ktrout
Initial Code
drop procedure if exists throw_error;
delimiter $$
CREATE PROCEDURE throw_error (errno BIGINT UNSIGNED, message VARCHAR(256))
BEGIN
SIGNAL SQLSTATE 'ERROR'
SET
MESSAGE_TEXT = message,
MYSQL_ERRNO = errno;
END $$
delimiter ;
Initial URL
Initial Description
procedure to throw application defined error
Initial Title
mysql procedure throw_error
Initial Tags
mysql, error
Initial Language
SQL