1 #创建商品表：2 create table product3 pid int primary key4 pname varchar205 price double6 category_id varchar327 ;8 INSERT INTO productpidpnamepricecategory_id VALUES1联想5000c001;9 INSERT INTO productpidpna

• 日期: 2026-11-07
• 标签: 社会

1. SELECT * FROM product WHERE pname='花花公子';
2. SELECT * FROM product WHERE price=800;
3. SELECT * FROM product WHERE price<>800;
4. SELECT * FROM product WHERE price>60;
5. SELECT * FROM product WHERE price BETWEEN 200 AND 1000;
6. SELECT * FROM product WHERE price=200 OR price=800;
7. SELECT * FROM product WHERE pname LIKE '%霸%';
8. SELECT * FROM product WHERE pname LIKE '香%';
9. SELECT * FROM product WHERE SUBSTRING(pname, 2, 1)='想';
10. SELECT * FROM product WHERE category_id IS NULL;

原文地址: https://www.cveoy.top/t/topic/fTws 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录