行列互换+分页查询

分页查询

查询 limit a b
注意行数的使用区分
a想要显示的起始行索引 包括此行(偏移量)从0开始
b是想要显示的个数
这个表格一共有14行 我现在使用分页查询来然他值显示5行
mysql> select * from emp ;
+-------+--------+-----------+------+------------+------+------+--------+
| empon | ename  | job       | mgr  | hiredate   | sal  | comm | deptno |
+-------+--------+-----------+------+------------+------+------+--------+
|  7369 | SMITH  | CLERK     | 7902 | 1980-12-17 |  800 | NULL |     20 |
|  7499 | ALLEN  | SALESMAN  | 7698 | 1981-02-20 | 1600 |  300 |     30 |
|  7521 | WARD   | SALESMAN  | 7698 | 1981-02-22 | 1250 |  500 |     30 |
|  7566 | JONES  | MANAGER   | 7839 | 1981-04-02 | 2975 | NULL |     20 |
|  7654 | MARTIN | SALESMAN  | 7698 | 1981-09-28 |