1、升降序查询
SELECT FROM(必需字句)
ORDER BY(排序字句);
eg. SELECT m.prod_name FROM milk_tea AS m ODER BY m. prod_month ;
1.1 按文本排序(按拼音首字母)
CONVERT(prod_name USING gbk)
1.2注意:排序字句一定是放在最后,跟分号在一起,默认升序,降序DESC,非默认升降序就近原则
Day 5
2、数据过滤(筛选行)
(1)SELECT 列 FROM 表 WHERE ;
<> , = , < , >
eg. SELECT m. prod_month FROM milk_tea AS m WHERE m. prod_name =‘奶糖’ ;
(2)如果列中有空值,用IFNULL(有空值列名,空值的代替值)
eg. SELECT m. prod_name FROM milk_tea AS m WHERE IFNULL(inprice, 0)=15 ;
(3)BETWEEN AND 在…范围内,闭区间
IS NULL
IS NOT NULL
eg. SELECT m. prod_name FROM milk_tea AS m WHERE sale_price IS NOT NULL ;