How do i create a mutex table in a database and ensure consistency using standard SQL.
Multiple clients must be able to perform the following sequence:
read value from table
update value in table
Unique client id's are not available.
Preferable only the statements select, update, insert and delete is used. The solution must work with at least oracle and mySQL.