I need to select a user record and then update the fields based on the values, in a transaction. Based on my understanding of transaction it should be fine. But I wanted to verify that it is safe to make the update query based on the record selected.Also what will happen if I forget to mention the transaction in the middle query in a transaction with 3 queries? Will it cause a deadlock or something?
Submitted September 29, 2020 at 09:17AM by AdwaithHSivam
No comments:
Post a Comment