START TRANSACTION, COMMIT, and ROLLBACK

https://dev.mysql.com/doc/refman/5.7/en/commit.html

START TRANSACTION
    [transaction_characteristic [, transaction_characteristic] ...]

transaction_characteristic: {
    WITH CONSISTENT SNAPSHOT
  | READ WRITE
  | READ ONLY
}

BEGIN [WORK]
COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
SET autocommit = {0 | 1}

 

关闭自动提交，使用START TRANSACTION statement:

START TRANSACTION;
SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
UPDATE table2 SET summary=@A WHERE type=1;
COMMIT;

 

To disable autocommit mode explicitly, use the following statement:

SET autocommit=0;

 

Statements That Cannot Be Rolled Back

有些语句不能被回滚，总体上来说，包括数据定义语言（DDL），比如说那些数据create 或者drop databases,还有那些create,drop,alter tables or stored routines.

你必须的保证你的事务中不包含这些语句。如果在事务中前面的语句不能回滚，后面的其他语句也将发生错误，将会造成整个事务的不能回滚。