问题:数据库查看事务隔离级别
select @@global.tx_isolation,@@tx_isolation;
报错:
mysql> select @@global.tx_isolation,@@tx_isolation;
ERROR 1193 (HY000): Unknown system variable 'tx_isolation'
mysql> select @@global.tx_isolation,@@tx_isolation;
ERROR 1193 (HY000): Unknown system variable 'tx_isolation'
我用的mysql8.0版本。tx_isolation在8.0版本更改为global.transaction_isolation
命令更改为:
select @@global.transaction_isolation,@@transaction_isolation;