Maybe this the correct behavior, but I am confused about
the statments below:
CREATE TABLE testing ( fmsg CHAR(1) DEFAULT 'N' );
INSERT INTO testing VALUES (NULL);
INSERT INTO testing VALUES ('Y');
INSERT INTO testing VALUES ('X');
INSERT INTO testing VALUES ('Y');
INSERT INTO testing VALUES (NULL);
INSERT INTO testing VALUES ('Y');
UPDATE testing SET fmsg = 'N' WHERE fmsg != 'Y';
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1 Changed: 1 Warnings: 0
Isn't NULL != 'Y' ?
- Diogo Zulli
----------------------[ www.sphynx.com.br ]---------------------------
"And once you have tasted flight, you will walk the earth with your
eyes turned skyward, for there you have been and there you long to
return" - Leonardo DaVinci
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
