1.mysql单个字段降序排序 select * from table order by id desc; 2.mysql单个字段升序排序 select * from table order by id asc; 3.mysql多个字段降序排序 select * from table order by id desc,name desc;