Jump to content

SQL Limit


karldesign

Recommended Posts

It doesn't make a great sense... LIMIT has the target to limit ( ;D) the number of rows you get out of a query. What you are asking is not limiting that, actually. You just want to skip 5 rows.

I can't figure out something else than fetching all rows and skipping first 5 in your php code (or what else)

Link to comment
https://forums.phpfreaks.com/topic/108674-sql-limit/#findComment-557275
Share on other sites

I am used to using LIMIT 5,5 to select 5 records from after the first 5 records.

 

What I would like to know is how do i select the remaining records from after the 5th record. would that be LIMIT 5,*?

 

cheers

You can't use negative values anymore, so try LIMIT 5, 999999999999.

 

Or whatever the max number is.

Link to comment
https://forums.phpfreaks.com/topic/108674-sql-limit/#findComment-557565
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.