第一种写法:
select * from table where id != null;
select * from table where id <> null;
select * from table where not id = '';
容易查不出来
使用is not null
select * from table where id is not null
第一种写法:
select * from table where id != null;
select * from table where id <> null;
select * from table where not id = '';
容易查不出来
使用is not null
select * from table where id is not null