![]() |
|
Don't ask to ask, just ask | |
PerlMonks |
Re: DBI - retrieving a specific rowby beebware (Pilgrim) |
on Feb 04, 2002 at 13:04 UTC ( [id://143223]=note: print w/replies, xml ) | Need Help?? |
I think this will be DB specific, but I know on MySQL you can use select * from table LIMIT 3,1 just to get the fourth result. Personally, if you are going to be accessing the data sequentially (ie first row, second row etc), you may as well do it in a loop as it will be a lot more effecient on the database servers cache system (it should 'anticipate' that you will request the next record, but if you then start a new query it may dump the cached data).
In Section
Seekers of Perl Wisdom
|
|