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


Recommended>>
1、Following in the footsteps of bitcoin and ethereum CHF coin becomes the new market trendsetter
2、The car is blocked how do I move it How do I check the bus schedule routes
3、B station responds to the suspicion of fast video off library no user account information was found to be leaked
4、Congratulations to CoreTech for winning the 2017 Citys Main Industrial Growth Enterprise Award
5、Xiaopengs chief scientist Guo Yandong Teslas advanced assisted driving was fooled by an orange

    已推荐到看一看 和朋友分享想法
    最多200字,当前共 发送

    已发送

    朋友将在看一看看到

    确定
    分享你的想法...
    取消

    分享想法到看一看

    确定
    最多200字,当前共

    发送中

    网络异常,请稍后重试

    微信扫一扫
    关注该公众号