MySQL Forums
Forum List  »  Newbie

Re: Wordpress Database Problem
Posted by: Barry Galbraith
Date: October 19, 2015 05:27PM

There is no inherent order in a RDBMS table.
You order the data when you retrieve it.

If you do
SELECT ... FROM ...
You'll get the rows in a random order.

But, if you
SELECT ... FROM ... ORDER BY ...
you'll get the rows in the order you asked for.

IOW.It doesn't matter what order your dump has the rows in if there was no 'ORDER BY" clause in the query that retrieved them.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
October 19, 2015 12:15PM
Re: Wordpress Database Problem
October 19, 2015 05:27PM
October 30, 2015 05:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.