MySQL doesn't have built in row-level locking, but they are chaning that.
The best thing to do, for now, is to have a record_locked column, and set it
to 1 if the record is in use. To lock the record, you would run a query like
update table_name set record_locked = 1 where id = ??? and record
Hello !
I want to make something like: There is one server and seval clients,
which all access the same database. The problem: If one user changes a
record, no other user should be able to change it.
Whats the general way to do it with MySQL ?
Regards
Martin
