Videos / PlanetScaleSeptember 202313:2084.1k viewsPagination in MySQL - offset vs. cursorWatch on YouTubeFiled under DatabasesChapters00:00Intro00:12How to pronounce paginate00:30The two pagination methods00:54We have bosses01:25Select * from people01:45Deterministic ordering03:20Limit/offset pagination05:17Shifting records in offset pagination06:12Cursor based pagination08:13Ordering by two columns09:23Cursor pagination drawbacks09:53Cursor pagination advantages10:50Summary of differences▶ Play