要获取MySQL中的最后30行,您需要使用ORDER BY DESC,然后使用LIMIT30。语法如下-select * from yourTableName order by yourColumnName DESC LIMIT 30;
让我们首先创建一个表-create table DemoTable1567
-> (
-> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY
-> );
使用插入命令在表中插入一些记录-insert into DemoTable1567 values(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),();
Records: 37 Duplicates: 0 Warnings: 0
使用select语句显示表中的所有记录-select * from DemoTable1567;
这将产生以下输出-+----+
| Id |
+----+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| 35 |
| 36 |
| 37 |
+----+
37 rows in set (0.00 sec)
以下是获取最后30行的查询-select * from DemoTable1567 order by Id DESC LIMIT 30;
这将产生以下输出-+----+
| Id |
+----+
| 37 |
| 36 |
| 35 |
| 34 |
| 33 |
| 32 |
| 31 |
| 30 |
| 29 |
| 28 |
| 27 |
| 26 |
| 25 |
| 24 |
| 23 |
| 22 |
| 21 |
| 20 |
| 19 |
| 18 |
| 17 |
| 16 |
| 15 |
| 14 |
| 13 |
| 12 |
| 11 |
| 10 |
| 9 |
| 8 |
+----+
30 rows in set (0.00 sec)