MySQL_视图_delect 和truncate 在使用事务时的区别

Delete成功回滚

#演示delete
SET autocommit = 0;
START TRANSACTION;
DELETE FROM account;
ROLLBACK;

 

Truncate不能回滚

#演示truncate
SET autocommit = 0;
START TRANSACTION;
TRUNCATE TABLE account;
ROLLBACK;