首页 > 代码库 > Phoenix分页实现

Phoenix分页实现

使用组合条件:
将组合列进行排序,根据组合列值设置上限,使用limit,进行分页查询;

  1. SELECT title, author, isbn, description
  2. FROM library
  3. WHERE published_date > 2010
  4. AND (title, author, isbn) > (?, ?, ?)
  5. ORDER BY title, author, isbn
  6. LIMIT 20


Phoenix分页实现