Set and Check Parameter “autocommit” in MySQL
The autocommit is ON when installed MySQL. Check the parameter： show variables like 'autocommit'; Set the parameter: OFF： SET autocommit=0; set autocommit = 'OFF'; ON： SET autocommit=0; set autocommit = 'ON';