-Transactional four-character (ACID) atomicity: (atomicity): The operation of a transaction is indivisible, either complete or not executed. Consistency: (consistency) Isolation: (Isolation) Persistence: (durability) operation instruction for mysql--transaction--Open transaction begin--COMMIT TRANSACTION commit--ROLLBACK TRANSACTION rollback-- The transaction is oriented to the current connection-either executing a commit or rollback the currently open transaction is automatically closed-in fact, the updated operation in MySQL is enabled by default, and is automatically committed by default-if you use begin to indicate that you are manually opening a transaction, commit represents a manual commit Service-If the high-volume update data (100w) starts a transaction manually or opens the transaction by default?--more efficient to manually open transactions-who is more secure? Manual requirement: The engine type of the table must be InnoDB type to use transactions, which is the default engine for MySQL tables
mysql--transactions