MySql 排序

//排序  desc 降序 asc  升序
select * from a order by clum1 desc, clum2 asc; 

//多字的合并排序
select * from a order by concat(clum1,clum2) desc