MySQL 异常错误码使用 及 对照表

DECLARE CONTINUE HANDLER FOR SQLWARNING, SQLEXCEPTION, NOT FOUND BEGIN GET DIAGNOSTICS CONDITION 1 code_t = MYSQL_ERRNO, msg = MESSAGE_TEXT; set session innodb_lock_wait_timeout=120; SET l_step1 = code_t; -- 如果是锁异常 告警 IF l_step1 = 1205 THEN CALL sp_SN_dbwarning(1, \'Sp_SN_ChargeBegin0_Acc\', \'lock\', v_HfSerialid, NULL, NULL); END IF; END;