mysql 事务管理&作业（13）

目录

事务

结束事务

设置事务隔离别

事务隔离级别

---

事务

Start transaction;

结束事务

提交       commit;

取消       rollback;

设置事务隔离别

Set session transaction isolation level 隔离级别；

事务隔离级别

Read uncommited       读未提交（脏读）

Read committed   读提交（不可重复读）

Repeatable read   可重复读（幻读）

Serializable    可串行化

 

 create database chapter06;
    -> use chapter06;
    -> create table account(
    -> id int primary key auto_increment,
    -> name varchar(40),
    -> money float
    -> );
    -> insert into account(name,money) values('a',1000);
    -> insert into account(name,money) values('b',1000)/

 

 select*from account/

 

  start transaction;
    -> update account set money=money-100 where name='a';
    -> update account set money=money+100 where name='b';
    -> commit/

 

  select*from account/

 

 start transaction;
    -> update account set money=money+100 where name='a';
    -> update account set money=money-100 where name='b'/

 

 select*from account/

 

 select*from account;

 

  start transaction;
    -> update account set money=money+100 where name='a';
    -> update account set money=money-100 where name='b';
    -> commit/

 select*from account/

 

  start transaction;
    -> update account set money=money-100 where name='a';
    -> update account set money=money+100 where name='b'/

 

 

 

 rollback/

 

 

 set session transaction isolation level read uncommitted/

 

 

 

 

 

 start transaction;
    -> update account set money=money-100 where name='a';
    -> update account set money=money+100 where name='b'/