Home >Database >Mysql Tutorial >Summary of transaction concept function definition and usage
MYSQL automatically submits by default, that is, if you submit a QUERY, it will be executed directly! We can disable automatic submission by set autocommit=0 and enable automatic submission by set autocommit=1. Only the INNODB engine in mysql supports transaction processing, and the default is automatic submission; another commonly used MYISAM engine does not support transactions and does not have transactions itself. Concept. It can be compared to the concept of Oracle transactions! ! ! You can avoid MySQL's automatic submission and implement rollback and other operations after encapsulating the API yourself! ! ! #include
1. Transaction Concept for Getting Started with MySQL
# #Introduction: MYSQL automatically submits by default, that is, if you submit a QUERY, it will be executed directly! We can pass
##Introduction: 1. Transaction concept: Concept: In the database, a transaction is a logical unit of work. A transaction is composed of one or more SQL statements that complete a set of related behaviors. Through the transaction mechanism
3.
小贝_mysql storage engine and transaction concept_MySQL
Introduction: Storage engine and transaction concept briefly: 1. What is Storage engine 2. What is transaction 1. In layman's terms, storage engine is the way to store and manage data. Visual example: Bicycle manager somewhere: Li, Zhang. Many people come to deposit and withdraw bicycles every day.4.
A concise learning tutorial on transaction concepts in MySQL_MySQL
##Introduction: This article mainly introduces the transaction concept in MySQL, which is the basic knowledge for introductory learning of MySQL. Friends in need can refer to it
The above is the detailed content of Summary of transaction concept function definition and usage. For more information, please follow other related articles on the PHP Chinese website!