好资源导航 » 文章资讯 » 获取前10行，后跟语法以单个MySQL查询显示其余行记录

获取前10行，后跟语法以单个MySQL查询显示其余行记录

2024-05-16 02:37:06 83

让我们首先创建一个表-

mysql> create table DemoTable
(
   Id int
);

使用插入命令在表中插入一些记录-

mysql> insert into DemoTable values(100);
mysql> insert into DemoTable values(101);
mysql> insert into DemoTable values(102);
mysql> insert into DemoTable values(103);
mysql> insert into DemoTable values(104);
mysql> insert into DemoTable values(105);
mysql> insert into DemoTable values(106);
mysql> insert into DemoTable values(107);
mysql> insert into DemoTable values(108);
mysql> insert into DemoTable values(109);
mysql> insert into DemoTable values(110);
mysql> insert into DemoTable values(111);
mysql> insert into DemoTable values(112);
mysql> insert into DemoTable values(113);
mysql> insert into DemoTable values(114);
mysql> insert into DemoTable values(115);

使用select语句显示表中的所有记录-

mysql> select *from DemoTable;

这将产生以下输出-

+------+
| Id   |
+------+
|  100 |
|  101 |
|  102 |
|  103 |
|  104 |
|  105 |
|  106 |
|  107 |
|  108 |
|  109 |
|  110 |
|  111 |
|  112 |
|  113 |
|  114 |
|  115 |
+------+
16 rows in set (0.00 sec)

以下是查询以获取前10行，然后是其余行-

mysql> select *from DemoTable LIMIT 999 offset 0;

这将产生以下输出-

+------+
| Id   |
+------+
|  100 |
|  101 |
|  102 |
|  103 |
|  104 |
|  105 |
|  106 |
|  107 |
|  108 |
|  109 |
|  110 |
|  111 |
|  112 |
|  113 |
|  114 |
|  115 |
+------+
16 rows in set (0.00 sec)