second last row of a table mysql

Question

I was playing in a MySQL database and wanted to only view the record that had second to last of table but did not get any row the query is given below What is the problem of my query

SELECT * FROM table WHERE id='(LAST_INSERT_ID()-1)'

Answer 1

LAST_INSERT_ID()-1 has no guarantee of pointing at an actual record. Try:

SELECT * FROM table ORDER BY id DESC LIMIT 1,1

Ideally you should be using something other than id to determine the age of a record, preferably a timestamp.