What does automatic transaction mean in Mysql data table

This article mainly introduces to you What does automatic transaction mean in mysql data table.

Automatic transactions, as the name suggests, are transactions that do not require manual work. The counterpart to automatic transactions is manual transactions. Regarding the introduction of manual transactions, we have introduced them to you in detail in previous articles. You need to Friends can choose to refer to these articles first.

【

What does transaction mean in mysql data table】

【

How to open transaction in Mysql data table】

[

How to set the rollback point for manual transactions in mysql data tables]

The focus of this section is to explain to you the definition of automatic transactions in

mysql data tables.

First of all, manual transactions, simply put, store the SQL statements we execute in the transaction log, and then manually open transactions, commit transactions, roll back transactions, etc. to process our transaction logs. for processing.

Then

automatic transaction means that we can directly submit our sql statement to the database without the need to open a transaction, commit a transaction, rollback, etc.

In our daily operations on the data table, we can find that a single select statement can query, delete, and insert the data table, and we do not need to submit it manually at all.

This is because our series of data table operations are in automatic transactions.

Under normal circumstances, the basic operations of the data table are basically in the default automatic transaction.

Below we can briefly summarize the definition of

mysql automatic transactions.

By default, the MySQL data table is enabled in auto-commit mode (the variable autocommit is ON).

That is to say, as long as you execute the DML (insert, update, delete) operation statement, MySQL will immediately commit the transaction implicitly (Implicit Commit).

Automatically commit transactions: every time a sql statement is executed, it is synchronized to the database.

This article is an introduction to the basic definition of automatic transactions in

mysql data tables. It should be very simple and easy to understand. I hope that through this introduction, it can be helpful to some novice friends. help! In later articles, we will continue to bring you specific knowledge points about automatic transactions in mysql data tables.

If you want to know more about mysql, you can follow the PHP Chinese website

mysql video tutorial

, everyone is welcome to refer to and learn!

The above is the detailed content of What does automatic transaction mean in Mysql data table. For more information, please follow other related articles on the PHP Chinese website!