2022-10-06-TIL

Today I Learned

Pagination with cursor in MySQL

  • https://bojithapiyathilake.medium.com/pagination-offset-vs-cursor-in-mysql-92cbf1a02cfa
  • https://stackoverflow.com/questions/38017054/mysql-cursor-based-pagination-with-multiple-columns
  • https://velog.io/@minsangk/%EC%BB%A4%EC%84%9C-%EA%B8%B0%EB%B0%98-%ED%8E%98%EC%9D%B4%EC%A7%80%EB%84%A4%EC%9D%B4%EC%85%98-Cursor-based-Pagination-%EA%B5%AC%ED%98%84%ED%95%98%EA%B8%B0
  • https://www.eversql.com/faster-pagination-in-mysql-why-order-by-with-limit-and-offset-is-slow/
  • https://stackoverflow.com/questions/6289729/mysql-update-query-with-limit