2021-08-08 事务的提交，回滚

SET autocommit = 0 --  关闭自动提交事务 暂时不要执行

-- 事务开启
START TRANSACTION -- 之后的都在同一个事务内

-- 提交
COMMIT

-- 回滚
ROLLBACK

-- 事务结束
SET autocommit = 1  -- 开启事务自动提交


SAVEPOINT -- 保存点 暂存
ROLLBACK TO SAVEPOINT -- 回滚到保存点
RELEASE SAVEPOINT -- 删除保存点

-- =======模拟场景 转账========
CREATE DATABASE shop CHARSET utf8 COLLATE utf8_general_ci
USE shop
CREATE TABLE `account`(
`id` INT(4) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(20) NOT NULL,
`money` DECIMAL(9,2) NOT NULL,
PRIMARY KEY(`id`)
)ENGINE=INNODB DEFAULT CHARSET=utf8

INSERT INTO `account`(`name`,`money`) 
VALUES('A',2000.00),('B',10000.00)

-- 转账
SET autocommit = 0;
START TRANSACTION
UPDATE `account` SET money = money-500 WHERE `name` = 'A' -- A减500
UPDATE `account` SET money = money+500 WHERE `name` = 'B' -- B加500

COMMIT; -- 提交事务

ROLLBACK;

SET autocommit = 1 -- 恢复自动提交