mysql - How to ensure data consistency under large batch update operations?

Question

During the execution of large batch update operations, the application layer is not aware of it. It will only know when the update is completed.
The current method that comes to mind is the a/b library mechanism. Are there any other methods?

Answer 1

For transactions, use try catch, if an error occurs, rollback, if not, commit