From: jiangwen jiang
Date: December 13 2012 7:28am
Subject: using LIMIT without ORDER BY
List-Archive: http://lists.mysql.com/mysql/228804
Message-Id: <CAKsJTrnSW5WHODqk+3CJ2Z+yT5=oiRo4jznovNGDG3a8inM=7g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=20cf301b64a91196bd04d0b6dd2a

--20cf301b64a91196bd04d0b6dd2a
Content-Type: text/plain; charset=ISO-8859-1

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

--20cf301b64a91196bd04d0b6dd2a--