Mysql如何根据两个字段排序？

假如我要对以下sql查询语句的查询结果进行排序(两个字段a,b)。

select  a,b,c,d,e  from  table_name;

---

1.先按照a升序，再按照b降序

select  a,b,c,d,e  from  table_name  order  by a,b desc;

也可以写为(因为默认升序，可以不写)：

select  a,b,c,d,e  from  table_name  order  by  a asc,b desc;

---

2.先按照a升序，再按照b升序

select  a,b,c,d,e  from  table_name  order by a,b;

也可以写为：

select  a,b,c,d,e  from  table_name  order by  a asc,b asc;

---

3.先按照a降序，再按照b升序

select  a,b,c,d,e  from  table_name  order by  a desc,b;

也可以写为：

select  a,b,c,d,e  from  table_name  order  by  a desc,b asc;

---

4.先按照a降序，再按照b降序

select  a,b,c,d,e  from  table_name  order by  a desc,b desc;

注：都降序必须写两个desc，因为排序不写默认asc。