Diogo Zulli wrote:
>
> 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
No, it is unknown.
---------------------------------------------------------------------
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
