在开发中经常会遇到这样的情况,一般空的概念分为两种,一种是null,另一种是空字符串。
//空字符串查询
select laojiujie from ehuanw where shucaijd='';
//空指针查询
select laojiujie from ehuanw where shucaijd is null;
或者:
//空字符串或者空指针
select laojiujie from ehuanw where shucaijd='' or shucaijd is null;
转载于:https://blog.51cto.com/332374363/1032282