Re: using the same field to be set in the update query and in the where clause
From: kushal bhattacharya <bhattacharya.kushal4_at_gmail.com>
Date: Fri, 10 Mar 2017 04:40:03 -0800 (PST)
Message-ID: <610e1c4e-b921-4c8e-9877-f0453dfe5ed8_at_googlegroups.com>
Date: Fri, 10 Mar 2017 04:40:03 -0800 (PST)
Message-ID: <610e1c4e-b921-4c8e-9877-f0453dfe5ed8_at_googlegroups.com>
hi,
What i want is i want to use the query as
update msg_table set state=2 where (msg_id=42 and (sock_fd=4711 and state=1)
but sometimes i see this beaviour
[Quoted] update msg_table set state=1 where (msg_id=42 and (sock_fd=4711 and state=1)
Received on Fri Mar 10 2017 - 13:40:03 CET