A lost update occurs when two different transactions are trying to update the same column on the same row within a database at the same time. Typically, one transaction updates a particular column in a particular row, while another that began very shortly afterward did not see this update before updating the same value itself. The result of the first transaction is then "lost", as it is simply overwritten by the second transaction. --https://morpheusdata.com/blog/2015-02-21-lost-update-db
This is also known as a "race condition". You already have your answer in your question: You "use a transaction", do you work, then COMMIT
the transaction in each thread. Now the nitty gritty:
START TRANSACTION
or disable autocommit: $mysqli->autocommit(FALSE);
in PHP for exampleROLLBACK
on errors and stop what you are doingCOMMIT
your changes when fully done, otherwise, the system will think there was an error and ROLLBACK
for you.Firebase Cloud Functions: PubSub, "res.on is not a function"
TypeError: Cannot read properties of undefined (reading 'createMessageComponentCollector')
I made a platform to remind me of some things I haven't doneI've stored this reminds into a database and now I want this PHP based Website to send me emails