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

admin

mysql 数据库desc和asc查看数据库排序
desc降序排列数据
" v$ a0 w9 Z1 U* _, G: J0 Q. A2 P mysql> select name,age from stu_info order by sex  desc;
Empty set (0.00 sec)
3 rows in set (0.00 sec)
# t9 ]+ ]9 M. `: \4 ]$ n     asc升序排序：
$ c; D8 p* J' }$ k        mysql> select name,age from stu_info order by sex asc;
" K# K# b. S7 k7 \ Empty set (0.00 sec)