大量数据的mysql分页查询

优化之前

SELECT
    a,
        b
FROM
    c
LIMIT 800000,5000    

 

优化之后

SELECT
    a,
b
FROM
    c
WHERE
    id >= (
        SELECT
            id
        FROM
            c
        LIMIT 800000,
        1
    )
LIMIT 5000