 <p>You are in fact getting your results in what is known as "table order", which may look like it's in the order that data was added to the table but that order is not stable. There are a number of operations that can change the order you are receiving results without changing the data in the table itself.</p> <p>To reproduce the sort of order you are seeing I'd suggest adding a column to your table of type <code>ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP</code>. This will give you a column to specifically order on and therefore reverse that order. You should probably add an index on that column as well if this operation is a frequent one.</p>