mysql查詢重復的,如何查看mysql數據庫隔離級別?
mysql默認的事務處理級別是'REPEATABLE-READ',也就是可重復讀
1.查看當前會話隔離級別
select @@tx_isolation;
2.查看系統當前隔離級別
select @@global.tx_isolation;
3.設置當前會話隔離級別
set session transaction isolatin level repeatable read;
4.設置系統當前隔離級別
set global transaction isolation level repeatable read;