#savepoint:节点名,设置保存点
#演示savepoint的使用
SET autocommit=0;
START TRANSACTION;
SELECT * FROM account;
DELETE FROM account WHERE id=6;
SAVEPOINT a;#设置保存点
DELETE FROM account WHERE id=8;
ROLLBACK TO a;#回滚到保存点处
INSERT INTO account VALUES(NULL,'wwww',1000);
删了id=6的,没删id=8的。