delete与truncate

演示delete

set autocommit=0;   开启事务
start TRANSACTION;
DELETE from table1;
ROLLBACK;

演示truncate

set autocommit=0;
start TRANSACTION;
TRUNCATE table table1;
ROLLBACK;

结论:delete成功回滚，truncate不回滚