showdatabases;use jtdb;showtables;showstatuslike'%lock%';#查询事物的隔离级别select @@tx_isolation;#set session transaction isolation level ;createdatabase test01;use test01;createtableuser(
id intprimarykeyauto_increment,
name varchar(20),
sex varchar(3),
age int)engine=innodbcharset= utf8;showtables;select @@tx_isolation;select*fromuser;insertintouser(name,age,sex)values("张三",18,"男");#设置事物隔离级别setsessiontransactionisolationlevelserializable;#开启事物starttransaction;select*fromuser;updateuserset age = age +1where id =1;commit;rollback;