I am not sure, but if its a MyISAM table, it should be ordered by the records insertion order, and in case of InnoDB it should be ordered by the clustered index, not necessarily it should be a defined one.
On Thu, Dec 13, 2012 at 12:58 PM, jiangwen jiang <jiangwen...@gmail.com>wrote: > hi, all: > > There's a confusion. I want to get all the data in table t by pages, using > Limit SQL without ORDER BY: > SELECT * FROM t Limit 0,10 > SELECT * FROM t Limit 10, 10 > ... > > Is it right without ORDER BY? > Is there any default order in table t, to make suer I can get all data in > the table? > > Thanks > Regards! > > White >
