Under what circumstances does MySQL use transactions?

Question

Could you please give me some guidance? Under what circumstances are MySQL transactions enabled?

Answer 1

The transaction usage scenario I understand is that the data needs to be jointly changed, such as payment, one needs to be subtracted and the other needs to be added. If it is subtracted but not added, there will be a problem. At this time, transactions can be used without completing the entire process. The previous operations are invalid

Answer 2

When operating multiple tables (checks are not counted, referring to additions, deletions, and modifications), you can use transactions

Answer 3

For example, payment