表信息

表数据如下
image-20220417112432207

is null

查询没有分类的商品

  1. select * from product where category_id is null;

效果
image-20220417112758143

is not null

查询有分类的商品

select * from product where category_id is not null;

效果
image-20220417113010467