MySQL 5.0 存储过程（2）事务 & SQLEXCEPTION

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;