CREATE TABLE al(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
money DOUBLE UNSIGNED
);
insert into al VALUES(null,'小刘',1500);
insert into al VALUES(null,'小张',100);
SELECT * from al;
BEGIN;-- 开启事物
UPDATE al SET money=money-200 where name='小刘';
UPDATE al SET money=money+200 where name='小张';
-- 提交回滚二选一 自己判断
COMMIT;-- 提交
ROLLBACK;-- 回滚