[KLUG Members] mysql and locking reads

[Jamie McCarthy]

Dirk, we chatted last night about your DB's READ and READU queries.
I think the MySQL equivalent of READU would be the SELECT ... FOR
UPDATE query.  That will lock the row(s) that are returned for both
reading and writing, until they are UPDATEd (hopefully quickly
afterwards).

If the rows only need to be locked for writing, there's a slightly
different command that could do that too.

More info:

http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#InnoDB_locking_reads
-- 
  Jamie McCarthy
 http://mccarthy.vg/
  jamie@mccarthy.vg