MySQL Forums
Forum List  »  Newbie

select limit records from 600000 records
Posted by: odelya glick
Date: October 30, 2009 06:14AM


i have a table with more than half a million records.

i tried to run select * from video limit 400000,400020;

but it takes it too long.

what is the best way to use limit for many records?

Options: ReplyQuote

Written By
select limit records from 600000 records
October 30, 2009 06:14AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.