mysql 数据库desc和asc查看数据库排序* v4 V+ o2 i7 P# T0 [# w5 K5 @
desc降序排列数据 * O D1 Q& z7 P, p( L mysql> select name,age from stu_info order by sex desc;0 W4 \+ z) ~5 o- |7 t# _/ n
Empty set (0.00 sec)( m: R5 a, F+ y8 l8 F9 H9 s
3 rows in set (0.00 sec)- ?+ T! y. A' L
asc升序排序:- ~' i& b* v) [! v0 w. c% H f: K# u
mysql> select name,age from stu_info order by sex asc;, X* k: l6 s% Q6 i
Empty set (0.00 sec) * F* c: F1 F: |8 K( G0 k