獲取前 10 行，然後使用單個 MySQL 查詢來顯示剩餘行記錄的語法

我們首先建立一個表 -

mysql> create table DemoTable
(
   Id int
);
Query OK, 0 rows affected (0.71 sec)

使用插入命令在表中插入一些記錄 -

mysql> insert into DemoTable values(100);
Query OK, 1 row affected (0.31 sec)
mysql> insert into DemoTable values(101);
Query OK, 1 row affected (0.26 sec)
mysql> insert into DemoTable values(102);
Query OK, 1 row affected (0.11 sec)
mysql> insert into DemoTable values(103);
Query OK, 1 row affected (0.64 sec)
mysql> insert into DemoTable values(104);
Query OK, 1 row affected (0.12 sec)
mysql> insert into DemoTable values(105);
Query OK, 1 row affected (0.08 sec)
mysql> insert into DemoTable values(106);
Query OK, 1 row affected (0.25 sec)
mysql> insert into DemoTable values(107);
Query OK, 1 row affected (0.44 sec)
mysql> insert into DemoTable values(108);
Query OK, 1 row affected (0.62 sec)
mysql> insert into DemoTable values(109);
Query OK, 1 row affected (0.10 sec)
mysql> insert into DemoTable values(110);
Query OK, 1 row affected (0.31 sec)
mysql> insert into DemoTable values(111);
Query OK, 1 row affected (0.94 sec)
mysql> insert into DemoTable values(112);
Query OK, 1 row affected (0.08 sec)
mysql> insert into DemoTable values(113);
Query OK, 1 row affected (0.35 sec)
mysql> insert into DemoTable values(114);
Query OK, 1 row affected (0.13 sec)
mysql> insert into DemoTable values(115);
Query OK, 1 row affected (0.25 sec)

使用 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)

更新於： 01-10-2019

134 瀏覽

開啟你的職業生涯 之旅

完成課程並獲得認證

立刻開始
廣告