mysql中,升序为asc,降序为desc。例如:

升序:select * from 表名 order by 表中的字段 asc(mysql中默认是升序排列,可不写)

select   *  from test order by name asc
select   *  from test order by name 

降序:select * from 表名 order by 表中的字段 desc

select   *  from test order by name desc

若要进行同时一个升序,一个降序,则如下:

order by 升序字段 asc,降序字段 desc。

select   *  from test order by name asc,id desc

来源:https://www.cnblogs.com/LYliangying/p/9576488.html