Our server in the interaction with the data often need some transactional operations, said check the related information using the database API is not recommended to do this, can easily lead to a deadlock, multi-threaded or multi-process operating conditions, if we are to achieve a transactional operation, how to achieve this, is there a more elegant solution? If your own server to reload the possibility of collapse, and how to solve?

CodePudding user response:

Odbc mysql client can even affairs

CodePudding user response:

Database itself to have affairs, deadlock is caused because you to the operation of the database is not correct
Through ADO, ODBC, etc., are a function of the transaction to implement transaction support,

CodePudding user response:

The learning to use a stored procedure!