博主刚开始用的是
select * from product where sale_price =null
这样子查不出来,需要用到下面的sql
select * from product where sale_price is null
当然,如果想要查出来不是null的,
select * from product where sale_price is not null
博主刚开始用的是
select * from product where sale_price =null
这样子查不出来,需要用到下面的sql
select * from product where sale_price is null
当然,如果想要查出来不是null的,
select * from product where sale_price is not null