mysql 存储过程事务

    DECLARE t_error INTEGER DEFAULT 0;   
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1;   
    START TRANSACTION;    
 7         delete from client;
    IF t_error = 1 THEN   
        ROLLBACK;   
    ELSE   
        COMMIT;   
    END IF; 

事务关键代码。

调用存储过程：Call 存储过程名字;