Mysql ORDER BY 排序多个字段

ORDER子句中定义了多个字段，则按照字段的先后顺序排序：

select * from tablename order by column1 desc, column2 asc, column3 desc