Shulou(Shulou.com)05/31 Report--

This article mainly introduces the relevant knowledge of "what is the way to start mysql transactions". The editor shows you the operation process through an actual case. The operation method is simple, fast and practical. I hope this article "what is the way to start mysql transactions" can help you solve the problem.

1. Explicitly start the transaction statement, begin or start transaction, commit commit, and roll back rollback.

2. Set autocomit=0, this command automatically shuts down the thread. As soon as the select statement is executed, the transaction starts and does not commit automatically until comit or rollback is actively executed or disconnected.

Example

-TRANSACTIONS- TRANSACTION 906574, ACTIVE 383sec1 lock struct (s), heap size 1136, 0 row lock (s), undo log entries 1MySQL thread id 71, OS thread handle 139874604435200, query id 9040045 172.17.0.1 server_234 on "how to start mysql transactions" is introduced here, thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.