Re: How to update multiple rows atomically

This UPDATE worked on DB2 UDB. So, it may be MySQL specific restriction.

UPDATE T
   set owner = 1
 WHERE (id = 2 or id = 3)
   and (SELECT count(*)

          from T
         WHERE (id = 2 or id = 3)
           and owner = 0)
       = 2;


-------------------------------------------------------------------

• Commands Entered ------------------------- SELECT * FROM T;

  ---

ID OWNER
----------- -----------

          1           0
          2           1
          3           1
          4           0
          5           0

  5 record(s) selected. Received on Sat Jul 29 2006 - 08:52:05 CEST