事务

CREATE DATABASE shop CHARACTER SET utf8 COLLATE utf8_general_ci
USE shop

CREATE TABLE `account`(
`id` INT(3) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(10) NOT NULL,
`money` DECIMAL(9,2) NOT NULL,
PRIMARY KEY (`id`)
)ENGINE= INNODB DEFAULT CHARSET = utf8

 --模拟转账：事务

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;--恢复默认值