3.0版本主键生成存储过程 完整版

DROP PROCEDURE IF EXISTS `UpTabPrimarykey1`;

CREATE DEFINER = `root`@`localhost` PROCEDURE `UpTabPrimarykey1`(in curkeyName varchar(50),
OUT keyValue int)
begin

DECLARE t_error INTEGER DEFAULT 0;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1;
START TRANSACTION;
select `value` into keyValue from CompnayTabKey1 where keyName=curkeyName for update;
set keyValue=keyValue+1;
update CompnayTabKey1 set value=keyValue where keyName=curkeyName;
IF t_error = 1 THEN
ROLLBACK;
ELSE
COMMIT;
END IF;
end;

 但是如果访问多了，应该会卡