极客教程MySQL 如何跳过前10个结果
要跳过前10个结果，请使用“limit偏移量”。 语法如下−
select *from yourTableName limit 10 offset lastValue;
让我们创建一个表以了解上述语法。 以下是创建表的查询−
mysql> create table SkipFirstTenRecords
−> (
−> StudentId int,
−> StudentName varchar(200)
−> );
Query OK, 0 rows affected (0.53 sec)
现在，您可以使用insert命令在表中插入一些记录。 查询如下−
mysql> insert into SkipFirstTenRecords values(100,'John');
Query OK, 1 row affected (0.12 sec)
mysql> insert into SkipFirstTenRecords values(101,'Johnson');
Query OK, 1 row affected (0.14 sec)
mysql> insert into SkipFirstTenRecords values(102,'Carol');
Query OK, 1 row affected (0.10 sec)
mysql> insert into SkipFirstTenRecords values(103,'Smith');
Query OK, 1 row affected (0.32 sec)
mysql> insert into SkipFirstTenRecords values(104,'Bob');
Query OK, 1 row affected (0.14 sec)
mysql> insert into SkipFirstTenRecords values(105,'David');
Query OK, 1 row affected (0.18 sec)
mysql> insert into SkipFirstTenRecords values(106,'Sam');
Query OK, 1 row affected (0.14 sec)
mysql> insert into SkipFirstTenRecords values(107,'Taylor');
Query OK, 1 row affected (0.23 sec)
mysql> insert into SkipFirstTenRecords values(108,'Ramit');
Query OK, 1 row affected (0.16 sec)
mysql> insert into SkipFirstTenRecords values(109,'Belly');
Query OK, 1 row affected (0.18 sec)
mysql> insert into SkipFirstTenRecords values(110,'Aaron ');
Query OK, 1 row affected (0.16 sec)
mysql> insert into SkipFirstTenRecords values(111,'Peter');
Query OK, 1 row affected (0.10 sec)
mysql> insert into SkipFirstTenRecords values(112,'Travis');
Query OK, 1 row affected (0.14 sec)
mysql> insert into SkipFirstTenRecords values(113,'Alex');
Query OK, 1 row affected (0.18 sec)
mysql> insert into SkipFirstTenRecords values(114,'Pat ');
Query OK, 1 row affected (0.11 sec)
显示我在表中插入的所有记录。 查询如下：
mysql> select *from SkipFirstTenRecords;
以下是输出−
+-----------+-------------+
| StudentId | StudentName |
+-----------+-------------+
| 100 | John |
| 101 | Johnson |
| 102 | Carol |
| 103 | Smith |
| 104 | Bob |
| 105 | David |
| 106 | Sam |
| 107 | Taylor |
| 108 | Ramit |
| 109 | Belly |
| 110 | Aaron |
| 111 | Peter |
| 112 | Travis |
| 113 | Alex |
| 114 | Pat |
+-----------+-------------+
15 rows in set (0.00 sec)
从上述表中跳过前10条记录的查询如下所示−
mysql> select *from SkipFirstTenRecords limit 10 offset 10;
由于我们跳过了前10条记录，因此以下输出仅显示最后5条记录−
+-----------+-------------+
| StudentId | StudentName |
+-----------+-------------+
| 110 | Aaron |
| 111 | Peter |
| 112 | Travis |
| 113 | Alex |
| 114 | Pat |
+-----------+-------------+
5 rows in set (0.00 sec)
阅读更多：MySQL 教程