MySQL 5.0 存储过程 (2)
事务的处理:
DECLARE c int default 0;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION Set c = 1;
SET AUTOCOMMIT = 0;
START TRANSACTION;
update tp_id set id_value = id_value + step
where id_name = 'CALL_ID';
if c = 1 then
rollback
else
commit;
end if;
SET AUTOCOMMIT = 1;