mysql基本语句_MySQL 基本语句三

继续进阶学习！

按照特定列进行大小排序：

desc 降序 asc 升序

select *from products order by price desc; *按照价格降序排列

select * from products order by quantity asc;*按照数量升序排列

select * from products order by price desc limit 3; 按照价格降序排列前三个

--

select * from products

where create_date>'2015-12-31'

order by price desc

limit 3;

好的，试着尝试解释下面语句：

select * from products

where create_date>'2015-12-31'

order by create_date desc, price desc

limit 3;

选择特定行：

select name, price, price+10 as new_price（列的名字）+10 from products(建立的表的名字);

命名特定行：

select name, price, price+10 as new_price（列的名字）+10 from products(建立的表的名字);

条件语句的使用：

select

*, IF (imageurl IS NULL, 'n/a', image_url) as image_url_detail 条件是空，填写n/a, 不然就输入之前的图片地址。

from products

where image_url IS NULL ;

分组

select 选定需要的列，输入列的名字

"name",

price ,

(case case的语句是给条件，给的条件从when开始，else用来表示其他条件，end来结尾

when price<=20 then "0-20"

when price >20 and price<30 then"20-30"

when price >30 and price<50 then"30-50"

ELSE "+_+"

END) as group

from products;