If you include an ORDER BY clause, and the contents of the table are not modified, then yes. Unexpected insertion of a row in the "middle" of the table (as ordered by your ORDER BY clause) may cause a row to be seen twice (if it happens at an index below the point your queries have reached) as it will push everything else "up" a row. Similarly, unexpected deletion of a row may cause a row to not be seen under the same circumstances as it will bring everything "down" a row.
-JF > -----Original Message----- > From: Jeff Barr [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 09, 2004 8:22 AM > To: [EMAIL PROTECTED] > Subject: Will series of limited selects return entire table? > > If I have a MyIsam table that is not subject to modification, > is a series of select calls like this: > > select * from table limit 0,100; > select * from table limit 100,100; > select * from table limit 200,100; > ... > > Guaranteed to return each row in the table exactly once (as long > as I keep going until the end)? > > My limited testing seems to say that this is the case. However, > the documentation is silent on this issue. I would prefer not > to count on this if is not guaranteed. > > Jeff; > > -- > * RSS Feeds: http://www.syndic8.com > * Blog: http://www.syndic8.com/~jeff/blog/ > * Developer Books: http://www.developer-books.com > * Resume: http://www.syndic8.com/~jeff/resume.html > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
