MySQL Commit
In MySQL database , the autocommit feature is set on by default (autocommit=on)
It can be turned off in three ways
1. in the config file, but this would affect all transactions (SET GLOBAL init_connect='SET AUTOCOMMIT=0)
2. by session (set autocommit=0)
3. At the start of a transactions as follows: START TRANSACTION, < statement >, COMMIT (OR ROLLBACK)
It can be turned off in three ways
1. in the config file, but this would affect all transactions (SET GLOBAL init_connect='SET AUTOCOMMIT=0)
2. by session (set autocommit=0)
3. At the start of a transactions as follows: START TRANSACTION, < statement >, COMMIT (OR ROLLBACK)
Comments