Re: using the same field to be set in the update query and in the where clause

From: Thomas 'PointedEars' Lahn <PointedEars_at_web.de>
Date: Sat, 11 Mar 2017 03:54:54 +0100
Message-ID: <40253699.fMDQidcC6G_at_PointedEars.de>


Axel Schwenke wrote:

> update msg_table set state=1 where (msg_id=42 and (sock_fd=4711 and
> state=1)

[sic]

> that would be a perfectly legal SQL statement. […]

… if a closing parenthesis were inserted or an opening one omitted.

-- 
PointedEars

Twitter: _at_PointedEars2
Please do not cc me. / Bitte keine Kopien per E-Mail.
Received on Sat Mar 11 2017 - 03:54:54 CET

Original text of this message