mysql - What's the most efficient way to select the last n rows in a table without changing the table's structure?

Question

What's the most efficient way to select the last n number of rows in a table using mySQL? The table contains millions of rows, and at any given time I don't know how large the table is (it is constantly growing). The table does have a column that is automatically incremented and used as a unique identifier for each row.

Answer 1

SELECT * FROM table_name ORDER BY auto_incremented_id DESC LIMIT n