All pastes #591796 Raw Edit

Untitled

public text v1 · immutable
#591796 ·published 2007-06-27 12:06 UTC
rendered paste body
mysql> CREATE TABLE t1 ( a INT );
Query OK, 0 rows affected (0.04 sec)

mysql> INSERT INTO t1 VALUES (1), (2), (NULL), (3), (NULL) ;
Query OK, 5 rows affected (0.00 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM t1 WHERE ISNULL(a);
+------+
| a    |
+------+
| NULL | 
| NULL | 
+------+
2 rows in set (0.00 sec)