Re: Yet another null question

[Roger Baklund]

doug@stripped wrote:
> I did not expect that null was not not-equal to 1. 

Any comparison with NULL returns NULL:

mysql> select null<>1,null>1,null<1,null=1;
+---------+--------+--------+--------+
| null<>1 | null>1 | null<1 | null=1 |
+---------+--------+--------+--------+
|    NULL |   NULL |   NULL |   NULL |
+---------+--------+--------+--------+
1 row in set (0.00 sec)

This is the correct and desired behaviour.

<URL: http://dev.mysql.com/doc/mysql/en/null-values.html >
<URL: http://dev.mysql.com/doc/mysql/en/working-with-null.html >
<URL: http://dev.mysql.com/doc/mysql/en/problems-with-null.html >

-- 
Roger