Home >Database >Mysql Tutorial >设置MySQL事务隔离级别_MySQL
设置MySQL事务隔离级别_MySQL
- WBOYOriginal
- 2016-06-01 13:02:552169browse
select @@tx_isolation; //查看隔离级别
set transaction isolation level read uncommitted; //设置读未提交级别
start transaction; //打开事务
rollback; //回滚
commit; //提交
set transaction isolation level read committed; //设置读提交级别
set transaction isolation level repeatable read; //设置可重复读（缺省），保证每次读的结果是一样的
set transaction isolation level serializable; //设置成序列化
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql支持的数据类型及其测试_MySQLNext article：Linux下MySQL源码安装完整版_MySQL