#进阶9:分页查询 /* 当要显示的数据,一页显示不全,需要分页提交sql请求 SELECT FROM JOIN ON WHERE GROUP BY HAVING ORDER BY LIMIT offset, size; offset:起始索引(从0开始) size:查询条目个数 */ USE myemployees; #案例1:查询前5条员工信息 SELECT * FROM employees LIMIT 5; #案例1:查询第11条~第25条员工信息 SELECT * FROM employees LIMIT 10, 15;