仅获取以下的最后五条记录是语法-select *from yourTableName order by yourColumnName DESC LIMIT 5;
让我们首先创建一个表-mysql> create table DemoTable820(
Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
CustomerName varchar(100)
);
使用插入命令在表中插入一些记录-mysql> insert into DemoTable820(CustomerName) values('Chris');
mysql> insert into DemoTable820(CustomerName) values('Robert');
mysql> insert into DemoTable820(CustomerName) values('David');
mysql> insert into DemoTable820(CustomerName) values('Bob');
mysql> insert into DemoTable820(CustomerName) values('Carol');
mysql> insert into DemoTable820(CustomerName) values('Adam');
使用select语句显示表中的所有记录-mysql> select *from DemoTable820;
这将产生以下输出-+----+--------------+
| Id | CustomerName |
+----+--------------+
| 1 | Chris |
| 2 | Robert |
| 3 | David |
| 4 | Bob |
| 5 | Carol |
| 6 | Adam |
+----+--------------+
6 rows in set (0.00 sec)
以下是将记录限制为仅最后五个结果的查询-mysql> select *from DemoTable820 order by Id DESC LIMIT 5;
这将产生以下输出-+----+--------------+
| Id | CustomerName |
+----+--------------+
| 6 | Adam |
| 5 | Carol |
| 4 | Bob |
| 3 | David |
| 2 | Robert |
+----+--------------+
5 rows in set (0.00 sec)