MySQL Learning note 02 Transaction autocommit Auto-commit

The MySQL default mode of operation is autocommit auto-commit mode. This means that unless a transaction is explicitly started, each query is executed automatically as a separate transaction. We can change whether the autocommit mode is auto-committed by setting the value of autocommit. You can view the current autocommit mode by using the following command.

' autocommit ' ; +---------------+-------+| variable_name | Value |+---------------+-------+| Autocommit    | On    |+---------------+-------+1inset (0.04 sec)

From the query results, we find that value is on, indicating that autocommit is turned on. We can change this pattern with the following SQL statement.

Set 0;

The value 0 and off are the same, of course, 1 means on. With the above setting autocommit=0, the user will remain in a transaction until a commit commit or ROLLBACK statement is executed to end the current transaction and start a new transaction again.

The MySQL default storage engine is the Myisam,myisam storage engine does not support transactional processing, so changing the autocommit has little effect. But will not error, so to use transaction processing of children's shoes be sure to determine what you are doing to support transactional processing, such as InnoDB. If you do not know that the storage engine for the table can view the build table by looking at the table statement, there is no storage engine that specifies the transaction type, and if you do not specify the storage engine by default, the MyISAM does not support transactions.
Of course, transaction processing is to ensure the atomicity, consistency, isolation and persistence of table data. These are to consume system resources, be careful to choose.

MySQL Learning note 02 Transaction autocommit Auto-commit