On 26/06/11 16:44, Michael Nolan wrote:
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
no...@tssi.com <mailto:no...@tssi.com>
I am guessing that '(field2 - 20)' is evaluated, and if non-zero it is
treated as true?
