SQL Retrieving the last record in a sql query

Question

I need to retrieve the last record in a mysql database table - is there a command for this?

Answer 1

Last by what order?

SELECT * FROM my_table ORDER BY something (DESC) LIMIT 1

Answer 2

Assuming you want the row with the largest auto-incrementing id, you can do this.

SELECT * FROM Table1 ORDER BY id DESC LIMIT 1