mysql 数据库desc和asc查看数据库排序

admin

mysql 数据库desc和asc查看数据库排序
desc降序排列数据
  e& s3 P  S/ ?/ y+ N! d mysql> select name,age from stu_info order by sex  desc;
& k7 P/ c3 t1 J% y# p' D% v Empty set (0.00 sec)
3 rows in set (0.00 sec)
: i; {. g6 M( x! f  x9 V     asc升序排序：
        mysql> select name,age from stu_info order by sex asc;
% h9 K0 e" ?2 P7 H1 M Empty set (0.00 sec)