delete与truncate
2019-07-22 本文已影响0人
rainbowz
演示delete
set autocommit=0; 开启事务
start TRANSACTION;
DELETE from table1;
ROLLBACK;
演示truncate
set autocommit=0;
start TRANSACTION;
TRUNCATE table table1;
ROLLBACK;
结论:delete成功回滚,truncate不回滚
演示delete
set autocommit=0; 开启事务
start TRANSACTION;
DELETE from table1;
ROLLBACK;
演示truncate
set autocommit=0;
start TRANSACTION;
TRUNCATE table table1;
ROLLBACK;
结论:delete成功回滚,truncate不回滚