MySQL 5.5新增SIGNAL异常处理(二)
TE '23000';
DECLARE CONTINUE HANDLER FOR con1
BEGIN
resignal SET schema_name = 'action',
table_name = 'action_tb',
message_text = 'Duplicated!',
mysql_errno = 22;
/*
signal con1 SET schema_name = 'action',
table_name = 'action_tb',
message_text = 'Duplicated!',
mysql_errno = 22;
www.2cto.com
*/
END;
INSERT INTO user_info VALUES (f_id);
END$$
DELIMITER ;
CALL sp_signal1(12);
www.2cto.com
Query : call sp_signal1(12)
Error Code : 22
Duplicated!
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
作者 四爷