MySql - 事务

事务的特性：原子性，一致性，隔离性，持续性

隔离性级别：未提交读，已提交读，可重复读，可串行化

CREATE DATABASE test;

USE test;

CREATE TABLE student(
		 sname VARCHAR(3) PRIMARY KEY,
		 num INT UNSIGNED
);

INSERT INTO student VALUES
('张三',1000),
('李四',1000);

-- 回滚
START TRANSACTION;
UPDATE student SET num = num-2000 WHERE sname = '张三';
UPDATE student SET num = num+2000 WHERE sname = '李四';
ROLLBACK;

-- 提交
START TRANSACTION;
UPDATE student SET num = num-100 WHERE sname = '张三';
UPDATE student SET num = num+100 WHERE sname = '李四';
COMMIT;

SELECT * FROM student;