Finding the last record in table

[dcjones]

Hi all.

I have looked at a lot of posts on finding record but can not find the solution I require.

I am trying to find out how to write a statement that will find the last record in a table. And at the same time display one of the fileds within the table relating to the last record.

Can anyone point me in the right direction please.

[laserlight]

To absolutely reliably find the last record, you need to keep track of when a record is inserted. Then, you order by the insertion date/time in reverse, and select the first row.

Of course, you can still do this ORDER BY ... LIMIT without recording the insertion date/time and just relying on an auto incremented id, but then you have to check your DBMS documentation to ensure that deleted ids will never be reused.