Advanced Search

Return to Snippet

Revision: 70286
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