select * from 表名 where 字段名 is null
示例:
select * from student where address is null
查询mysql数据库表中字段不为null的记录:
select * from 表名 where 字段名 is not null
示例:
select * from student where address is not null
未经允许不得转载:吾爱主机之家 » MySQL判断字段是否为Null
select * from 表名 where 字段名 is null
示例:
select * from student where address is null
查询mysql数据库表中字段不为null的记录:
select * from 表名 where 字段名 is not null
示例:
select * from student where address is not null
未经允许不得转载:吾爱主机之家 » MySQL判断字段是否为Null