What are the methods for mysql to start a transaction

This article mainly introduces "what are the methods for mysql to start transactions". In daily operation, I believe many people have doubts about the methods for mysql to start transactions. Xiaobian consulted various materials and sorted out simple and easy operation methods. I hope to help you answer the doubts about "what are the methods for mysql to start transactions"! Next, please follow the small series to learn together!

The transactions in mysql must have been touched by everyone. After we have mastered the basic concepts, we can try to practice the transaction initiation. The specific two methods are as follows:

1. Display the start transaction statement, begin or starttransaction. The commit statement is commit, and the rollback statement is rollback.

setautocommit=0, this command automatically closes the thread.

If only a select statement is executed, the transaction starts and is not automatically committed. Until the commit or rollback statement is actively executed, or the connection is disconnected.

It is recommended to use setautocommit=1 to initiate transactions by displaying sentences.

Long-term transactions can be queried in the innodb_trx table in the information_schema library, as follows:

examples

select * from information_schema.innodb_trx where TIME_TO_SEC(timediff(now(),trx_started))>60 At this point, the study of "what are the methods of mysql to start transactions" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!