mysql查询空值以NULL值填充_MySQL 使用sql查询列值为NULL(空值)的行信息的方法分享...

摘要:

下文讲述MySQL数据库中，我们查询列值为NULL(空值)的方法分享，如下所示:

实现思路:

使用ISNULL对列值进行检测，如果返回true,则代表列值为NULL

mysql > create table `maomao365.com`(

-> keyId int,

-> info varchar(60));

Query OK, 0 rows affected (0.00 sec)

mysql> insert into `maomao365.com`(keyId,info)values(1,null);

Query OK, 1 row affected (0.00 sec)

mysql> insert into `maomao365.com`(keyId,info)values(2,null);

Query OK, 1 row affected (0.00 sec)

mysql> insert into `maomao365.com`(keyId,info)values(3,null);

Query OK, 1 row affected (0.00 sec)

mysql> insert into `maomao365.com`(keyId,info)values(4,'other');

Query OK, 1 row affected (0.00 sec)

mysql> select keyId,info from `maomao365.com` where isnull(info);

+-------+------+

| keyId | info |

+-------+------+

| 1 | NULL |

| 2 | NULL |

| 3 | NULL |

+-------+------+

3 rows in set (0.00 sec)