Tim Wood wrote: > a-- select test_id from tests where status=1 and priority < 11 order by
priority b-- update tests set status=2 where test_id = <result of query above>
What's the best way to ensure that a single client executes both a and b atomically so that no other client can show up and execute an 'a' between another client's a and b ?
client A should use LOCK TABLES on tests to obtain exclusive read/write access on it until it is done with what it's doing.
http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
