Skip to main content

sql - limit实现分页

· One min read
_sql := "select tid, bid, cover, title,limit_content,create_time,see,comment from blog where draft = '0' and title like CONCAT('%',?,'%') order by id desc limit ?,? "
// to do
rows, err := stmt.Query(title, (page-1)*FRONT_SIZE, FRONT_SIZE)

limit A, B: A是起始位置,等于(pageNum-1)*SIZE, B为SIZE(相当于步长)

实现前端分页API需要返回2个数据:

  • 总页数
  • 前端给定页数n,返回第n页的数据