在mysql中,查询某字段为NULL时,切记不可用 = null,
而是 is null,不为空则是 is not null
select * from table_name where column_name is null;
select * from table_name where column_name is not null;
判断字符串为空字符串时用 = '',
select * from table_name where column_name = '';