how to order results from a table in MYSQL by the same order as when added to the table?

If I added a record yesterday and one today, how do I order the results by 'select * from table_name' by getting the entry added today first 开发者_StackOverflow中文版and then the older ones?

You'll need to timestamp and order by it, or order by a field with auto increment or similar.

If your primary key field is an auto-incremented integer, then you can do the following:

SELECT * FROM table_name ORDER BY pk_column DESC

If you're not using an auto-incremented integer for your primary key, then you'll need to do as Andre suggested and timestamp your rows.

Unless records are deleted, they are stored right in the order they were inserted. If records are deleted, new records are inserted not in a subsequent order. You then need to explicitly order by an "auto-incremented" ID field or a timestamp or something similar (if your table structure does provide any of these).