MySQL 事务执行（模拟转账）

20. NOT NULL COMMENT ‘姓名’,
    money DECIMAL(9,2) NOT NULL COMMENT ‘余额’,
    PRIMARY KEY(id)
    )ENGINE=INNODB DEFAULT CHARSET = utf8

INSERT INTO account VALUES
(1,‘张三’,1000.00),
(2,‘李四’,600.00),
(3,‘王五’,100.80),
(4,‘赵老六’,8000.88);

SELECT * FROM account
– 模拟转账
SET autocommit = 0;
START TRANSACTION;
UPDATE account SET money = money-200 WHERE id = 1;
– 转账到王五 200 ，一旦下面的出错，钱就出错了；
UPDATE account SET money = money+200 WHERE name = ‘王五’;
COMMIT;
ROLLBACK;
SET autocommit = 1;