Mysql 成长之路（三）表的查询与升序、降序排列结果

查看表原始数据

mysql> select * from simple_account;
+----+-----------+-------+-----+---------+
| id | name      | sex   | age | money   |
+----+-----------+-------+-----+---------+
|  1 | Tom       | man   |  20 | 4539.02 |
|  2 | Jack      | man   |  19 | 2109.50 |
|  3 | 原氏      | man   |  17 |  666.66 |
|  4 | 半藏      | man   |  22 | 1666.66 |
|  5 | 天使      | woman |  23 | 9700.00 |
|  6 | 莫伊拉    | woman |  30 | 5980.02 |
+----+-----------+-------+-----+---------+
6 rows in set (0.00 sec)

按money列升序排列

order by column_name

mysql> select * from simple_account order by money;
+----+-----------+-------+-----+---------+
| id | name      | sex   | age | money   |
+----+-----------+-------+-----+---------+
|  3 | 原氏      | man   |  17 |  666.66 |
|  4 | 半藏      | man   |  22 | 1666.66 |
|  2 | Jack      | man   |  19 | 2109.50 |
|  1 | Tom       | man   |  20 | 4539.02 |
|  6 | 莫伊拉    | woman |  30 | 5980.02 |
|  5 | 天使      | woman |  23 | 9700.00 |
+----+-----------+-------+-----+---------+
6 rows in set (0.00 sec)

按money列降序排列

order by column_name desc

mysql> select * from simple_account order by money desc;
+----+-----------+-------+-----+---------+
| id | name      | sex   | age | money   |
+----+-----------+-------+-----+---------+
|  5 | 天使      | woman |  23 | 9700.00 |
|  6 | 莫伊拉    | woman |  30 | 5980.02 |
|  1 | Tom       | man   |  20 | 4539.02 |
|  2 | Jack      | man   |  19 | 2109.50 |
|  4 | 半藏      | man   |  22 | 1666.66 |
|  3 | 原氏      | man   |  17 |  666.66 |
+----+-----------+-------+-----+---------+
6 rows in set (0.00 sec)