Skip to content

Instantly share code, notes, and snippets.

@appleshan

appleshan/mysql 分页

Last active June 19, 2018 06:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save appleshan/d324e18833b4569b6c9f3a587a4223b9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save appleshan/d324e18833b4569b6c9f3a587a4223b9 to your computer and use it in GitHub Desktop.
Download ZIP
mysql 数据库基础
Raw
mysql 分页
* mysql`limit`函数：`limit(1,6)` 查询从第一条数据后面的6条数据
* `select * from table limit (pageNo-1)*pageSize,pageSize;`
* 其中start是页码，limit是每页显示的条数。
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment