mysql 数据库desc和asc查看数据库排序 3 [% o; N$ B0 I' ~& a' Xdesc降序排列数据 ! V) ^5 e* \+ z1 |6 u# V4 D9 ], z mysql> select name,age from stu_info order by sex desc;' C4 @* p% q0 f7 h
Empty set (0.00 sec) - O6 ~4 {1 x! S& e 3 rows in set (0.00 sec)) J* G) z4 O. B
asc升序排序: , L" R3 ]" ^- e% V" T2 C1 ^5 X mysql> select name,age from stu_info order by sex asc; 8 M) w9 ~$ h9 C k s8 O Empty set (0.00 sec)5 A. {( d! \. U, j6 ^: K