MySQL ORDER BY代码笔记

mysql> select * from testB;
+----+-------+---------+------------+
| id | name  | address | time       |
+----+-------+---------+------------+
|  1 | c语言 | 昨天    | 2011-09-09 |
|  2 | MySQL | 今天    | 2018-06-06 |
|  3 | C++   | 明天    | 2018-09-09 |
|  4 | GO    | 未来    | 2019-09-08 |
|  5 | C++   | 某刻    | 1668-02-28 |
|  6 | PHP   | 某月    | 1068-02-28 |
|  8 | C#    | 某日    | 1168-02-28 |
|  9 | JAVA  | 某年    | 1018-02-28 |
| 12 | BAISC | 某刻    | 1268-02-28 |
+----+-------+---------+------------+
9 rows in set (0.00 sec)

mysql> select * from testB order by time ASC;
+----+-------+---------+------------+
| id | name  | address | time       |
+----+-------+---------+------------+
|  9 | JAVA  | 某年    | 1018-02-28 |
|  6 | PHP   | 某月    | 1068-02-28 |
|  8 | C#    | 某日    | 1168-02-28 |
| 12 | BAISC | 某刻    | 1268-02-28 |
|  5 | C++   | 某刻    | 1668-02-28 |
|  1 | c语言 | 昨天    | 2011-09-09 |
|  2 | MySQL | 今天    | 2018-06-06 |
|  3 | C++   | 明天    | 2018-09-09 |
|  4 | GO    | 未来    | 2019-09-08 |
+----+-------+---------+------------+
9 rows in set (0.01 sec)

mysql> select * from testB order by time DESC;
+----+-------+---------+------------+
| id | name  | address | time       |
+----+-------+---------+------------+
|  4 | GO    | 未来    | 2019-09-08 |
|  3 | C++   | 明天    | 2018-09-09 |
|  2 | MySQL | 今天    | 2018-06-06 |
|  1 | c语言 | 昨天    | 2011-09-09 |
|  5 | C++   | 某刻    | 1668-02-28 |
| 12 | BAISC | 某刻    | 1268-02-28 |
|  8 | C#    | 某日    | 1168-02-28 |
|  6 | PHP   | 某月    | 1068-02-28 |
|  9 | JAVA  | 某年    | 1018-02-28 |
+----+-------+---------+------------+
9 rows in set (0.00 sec)