Mysql-design of PHP database commit transaction mode

I am not personally familiar with transactions, but in fact, transactions are an important part of a project. I would like to discuss with you the transaction model, we can learn more about transaction processing methods based on this discussion. Take Mysql as an example: to execute a transaction mode, you need to disable MYSQ... I am not personally familiar with transactions, but in fact, transactions are an important part of a project. I would like to discuss with you the transaction model, we can learn more about transaction processing methods based on this discussion.

Take Mysql as an example:

To execute the transaction mode once, you need to disable the MYSQL automatic commit mode, and then submit the SQL statements in sequence. If all statements pass, success and related processing are returned.

I don't know how people generally design it?
You can go to the Code logic step and scenario application introduction!

Reply content:

I am not personally familiar with transactions, but in fact, transactions are an important part of a project. I would like to discuss with you the transaction model, we can learn more about transaction processing methods based on this discussion.

Take Mysql as an example:

To execute the transaction mode once, you need to disable the MYSQL automatic commit mode, and then submit the SQL statements in sequence. If all statements pass, success and related processing are returned.

I don't know how people generally design it?
You can go to the Code logic step and scenario application introduction!

This is simple. Transaction operations are generally performed on two or more multi-Table operations. If the SQL Execution of one of the tables fails, all SQL statements are executed and abolished, that is to say, when a transaction is rolled back to its original state, the bank's transfer operation must be a transaction. Zhang San will send 100 yuan to Li Si, Zhang San's account-100 yuan, and Li Si's account + 100 yuan, if Michael fails to operate-100, then Michael's + 100 fails. If no things are needed, don't let Michael die, or the bank loses.