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>
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