Shulou(Shulou.com)06/01 Report--

There is a parameter init_connect that does this, which defines the query that is automatically executed when each session is established, that is, initializing the session.

Depending on this parameter, there are three ways to disable autocommit:

1.

Mysql > set global init_connect='SET autocommit=0'

Query OK, 0 rows affected (0.00 sec)

Mysql > show variables like'init_connect';+-+-+

| | Variable_name | Value |

+-+ +

| | init_connect | SET autocommit=0 |

+-+ +

1 row in set (0.00 sec) 2. Set it in the initialization parameter file

[mysqld]

Init_connect='SET autocommit=0'

3. Add the command line argument-init_connect='SET autocommit=0' when starting mysql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.