我有很多delete from table where id = "1";delete from table where id = "3";delete from table where id = "12";delete from table where id = "23";..........等等的删除语句,我想写个事务,如果其中一个执行不成功我都要回滚?这个事务要怎么写呢?
调试欢乐多
begin
delete from table where id = "1";delete from table where id = "3";delete from table where id = "12";delete from table where id = "23";..........commit or rollback
delete from table where id = "1";delete from table where id = "3";delete from table where id = "12";delete from table where id = "23";.......... commit or rollback 就这样写就可以吗?他中途出现失败的情况就会全部回滚吗?没有错误就通过?这样写就可以了吗?