Problem solving for null queries
Just replace tx_Isolation with transaction_isolation
In the process of learning mysql, I want to query the isolation level of the current database
thusSHOW VARIABLES LIKE 'tx_Isolation';
found to be empty, as shown in
So I went and checked the official documentation
transaction_isolation was added as an alias tx_isolation in mysql 5.7.20, which is now deprecated and removed in MySQL 8.0. Application transaction_isolation should be adjusted to give preference to tx_isolation.
After switching to transaction_isolation, you can query the isolation level of mysql8's current default things normally
A small problem, for the record