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]
