I have some data in mysql table. I want each record to be used only once. So I have "is_used" column.
But if someone select data before the update query he will not know that record is already used.
I have some data in mysql table. I want each record to be used only once. So I have "is_used" column.
But if someone select data before the update query he will not know that record is already used.
If this is a huge concern, you should look into the various options for locking. This is a concurrency issue.