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
nolan@tssi.com
I am guessing that '(field2 - 20)' is evaluated, and if non-zero it is treated as true?