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:
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--