mysql 数据库desc和asc查看数据库排序) I# _5 C5 Z K( p/ k# m
desc降序排列数据& H' w. D2 @5 \/ `
mysql> select name,age from stu_info order by sex desc;7 r. L. l4 {5 A
Empty set (0.00 sec) 9 @& b7 h8 q% q6 ?- B6 J& j; R 3 rows in set (0.00 sec)2 g4 W0 \. D3 y) g* ]% O! Z
asc升序排序: 7 F4 L" g5 r, a% y4 a! | mysql> select name,age from stu_info order by sex asc; 5 c7 T# ]$ ]% X9 E2 T: J+ } Empty set (0.00 sec): v1 l% Y/ q2 p+ V1 j