在MySQL中获取最后30行
要获取MySQL中的最后30行，您需要使用ORDERBYDESC，然后使用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)