SQL 200 Row Limit – How to Implement Pagination or Infinite Scroll?

xnod · 2025-02-03T16:01:35.910Z

스크린샷 2025-02-01 오후 7.54.021580×774 108 KB

Hi everyone,

I’m currently developing a search-based website using MySQL as the database server. However, I’ve encountered a limitation where SQL queries return a maximum of 200 rows when fetched through the connector.

The issue is that my search results often exceed this 200-row limit, and I need a way to display more results—either through pagination or infinite scrolling.

I’ve been stuck on this problem for two days now and haven’t been able to make progress. Could anyone guide me on how to properly implement pagination or infinite scroll to fetch and display additional results beyond the 200-row limit?

Your help would be greatly appreciated!

Thank you!

system · 2025-04-14T16:01:45.158Z

This topic was automatically closed after 70 days. New replies are no longer allowed.