开启事务
start transaction;
结束事务
提交 commit;
取消 rollback;
设置事务隔离基别
set session transaction isolation level 隔离级别;
事务隔离级别
read uncommitted 读未提交(脏读)
read committed 读提交(不可重复读)
repeatable read 可重复读(幻读)
serializable 可串行化
start transaction;
提交 commit;
取消 rollback;
set session transaction isolation level 隔离级别;
read uncommitted 读未提交(脏读)
read committed 读提交(不可重复读)
repeatable read 可重复读(幻读)
serializable 可串行化