看看http://dev.mysql.com/doc/refman/5.0/en/declare-
handler.html
基本上,您声明错误处理程序,它将调用回滚
START TRANSACTION;DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; EXIT PROCEDURE; END;COMMIT;

看看http://dev.mysql.com/doc/refman/5.0/en/declare-
handler.html
基本上,您声明错误处理程序,它将调用回滚
START TRANSACTION;DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; EXIT PROCEDURE; END;COMMIT;