Re: An amusing MySQL weakness--not!
От
Gavin Flower
Тема
Re: An amusing MySQL weakness--not!
Дата
Msg-id
4E06C6FE.8060701@archidevsys.co.nz
Ответ на
An amusing MySQL weakness--not! (Michael Nolan)
Список
Дерево обсуждения
An amusing MySQL weakness--not! Michael Nolan <htfoot@gmail.com>
Re: An amusing MySQL weakness--not! Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: An amusing MySQL weakness--not! Darren Duncan <darren@darrenduncan.net>
Re: An amusing MySQL weakness--not! Vincent Veyron <vv.lists@wanadoo.fr>
Re: An amusing MySQL weakness--not! Stephen Frost <sfrost@snowman.net>
Re: An amusing MySQL weakness--not! Vincent Veyron <vv.lists@wanadoo.fr>
Re: An amusing MySQL weakness--not! Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: An amusing MySQL weakness--not! Leif Biberg Kristensen <leif@solumslekt.org>
Re: An amusing MySQL weakness--not! Vincent Veyron <vv.lists@wanadoo.fr>
Re: An amusing MySQL weakness--not! Pavel Stehule <pavel.stehule@gmail.com>
Re: An amusing MySQL weakness--not! Vincent Veyron <vv.lists@wanadoo.fr>
Re: An amusing MySQL weakness--not! merlyn@stonehenge.com (Randal L. Schwartz)
On 26/06/11 16:44, Michael Nolan wrote:
I am guessing that '(field2 - 20)' is evaluated, and if non-zero it is treated as true?
Earlier today I was working on a MySQL database (not by choice, I assure you),
and I typed a statement like this:
Update tablexyz set field1 = '15' where field2 - 20;
The '-' was supposed to be an equal sign, but MySQL executed it anyway. (Field2 is an integer.)
I was not amused.
PostgreSQL reports this as an error, of course.
--
Mike Nolan
nolan@tssi.com
I am guessing that '(field2 - 20)' is evaluated, and if non-zero it is treated as true?
В списке pgsql-general по дате отправления
