Re: How to update multiple rows atomically
From: Cimode <cimode_at_hotmail.com>
Date: 29 Jul 2006 07:51:44 -0700
Message-ID: <1154184704.003745.50810_at_i42g2000cwa.googlegroups.com>
Date: 29 Jul 2006 07:51:44 -0700
Message-ID: <1154184704.003745.50810_at_i42g2000cwa.googlegroups.com>
Your problem is not about locking really. Transactional locking is a just consequence of transaction isolation mode on an N user connected basis. Isolation mode is purely technology bound as each SQL DBMS implementation has its own rules...
Marshall wrote:
> Tonkuma wrote:
> > This UPDATE worked on DB2 UDB. So, it may be MySQL specific
> > restriction.
>
> THANK YOU!
>
> Having only MySQL to test against is like having brain damange.
> One never knows if one's experimental results are completely
> invalid for reasons having nothing to do with the experiment.
>
>
> Marshall
Received on Sat Jul 29 2006 - 16:51:44 CEST