Cách ORDER BY theo cột AUTO_INCREMENT trong MySQL

Tạo bảng:

mysql> CREATE TABLE DemoTable(Id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName VARCHAR(100)); Query OK, 0 rows affected (0.70 sec)

Chèn bản ghi:

mysql> INSERT INTO DemoTable(FirstName) VALUES('Chris'); Query OK, 1 row affected (0.22 sec) mysql> INSERT INTO DemoTable(FirstName) VALUES('Robert'); Query OK, 1 row affected (0.16 sec) mysql> INSERT INTO DemoTable(FirstName) VALUES('David'); Query OK, 1 row affected (0.15 sec) mysql> INSERT INTO DemoTable(FirstName) VALUES('Mike'); Query OK, 1 row affected (0.24 sec) mysql> INSERT INTO DemoTable(FirstName) VALUES('Adam'); Query OK, 1 row affected (0.15 sec) mysql> INSERT INTO DemoTable(FirstName) VALUES('Carol'); Query OK, 1 row affected (0.12 sec)

Hiển thị:

mysql> SELECT * FROM DemoTable;

Kết quả:

+----+-----------+ | Id | FirstName | +----+-----------+ | 1  | Chris     | | 2  | Robert    | | 3  | David     | | 4  | Mike      | | 5  | Adam      | | 6  | Carol     | +----+-----------+ 6 rows in set (0.00 sec)

Truy vấn ORDER BY AUTO_INCREMENT (Id):

mysql> SELECT * FROM DemoTable ORDER BY Id DESC;

Kết quả:

+----+-----------+ | Id | FirstName | +----+-----------+ | 6  | Carol     | | 5  | Adam      | | 4  | Mike      | | 3  | David     | | 2  | Robert    | | 1  | Chris     | +----+-----------+ 6 rows in set (0.00 sec)