mysql 缓冲区分析_MySQL 在读取异常错误缓冲区方面的提升（MySQL5.6）

DELIMITER $$

USE `new_t`$$

DROP PROCEDURE IF EXISTS `sp_do_update`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_do_update`(

IN f_id INT,

IN f_log_time VARCHAR(255),

IN f_end_time VARCHAR(255)

)

BEGIN

DECLARE i_con1 TINYINT DEFAULT 0;

DECLARE i_code CHAR(5) DEFAULT '00000';

DECLARE i_msg TEXT;

DECLARE i_rows INT;

DECLARE i_con1 CONDITION FOR 1048; — 这个错误代码代表字段限制不能NULL。

DECLARE CONTINUE HANDLER FOR i_con1

BEGIN

SET i_con1 = 1;

get diagnostics CONDITION 1

i_code = returned_sqlstate, i_msg = message_text;

END;

UPDATE t_datetime

SET log_time = IFNULL(f_log_time,NULL),

end_time = IFNULL(f_end_time,NULL)

WHERE id = f_id;

IF i_con1 = 0 THEN

get diagnostics i_rows = ROW_COUNT;

SET @i_result = CONCAT("Update succeeded, affected ", i_rows,'.');

ELSE

SET @i_result = CONCAT('Update failed, error code is 1042, related message is ',i_msg,'.');

END IF;

SELECT @i_result;

END$$

DELIMITER ;