把字段不为null和≠“”的情况除开后分组排序计数，如果>0说明存在有值行数据SELECT COUNT(*) FROM table WHERE column IS NOT NULL OR column<> "" GROUP BY column
select * from 表名 where 字段名 is null
