如何解决MySQL分页时出现的数据重复问题
大家好,今天给大家分享如何解决MySQL分页时出现的数据重复问题。
0 问题描述
SELECT
`post_title`,
`post_date`
FROM
post
WHERE
`post_status` = "publish"
ORDER BY
view_count desc
LIMIT
5, 5
SELECT
*
FROM
post
WHERE
post_status = "publish"
ORDER BY
view_count desc
LIMIT
5, 5
SELECT
`post_title`,
`post_date`
FROM
post
WHERE
`post_status` = "publish"
ORDER BY
view_count desc,
ID asc
LIMIT
5, 5
1 分析问题
MySQL 5.5 没有这个优化,所以也就不会出现这个问题。
(1) SELECT
(2) DISTINCT <select_list>
(3) FROM <left_table>
(4) <join_type> JOIN <right_table>
(5) ON <join_condition>
(6) WHERE <where_condition>
(7) GROUP BY <group_by_list>
(8) HAVING <having_condition>
(9) ORDER BY <order_by_condition>
(10) LIMIT <limit_number>