mysql get last 10 records in a table
 

Does anybody know whether it is possible to get the last 10 records in a table, without having to load the whole contents of the table? If that's not possible then what other way would you recommend.

If it has some sort of sequential id or date associated with the record, you could do this:

SELECT * FROM mytable ORDER BY seq_id DESC LIMIT 10;

Basically, this puts the last entries on top (via sorting in descending order), then limiting the results to 10 via LIMIT.

Thanks a bunch IR that was exactly what I was looking for.

Glad you got it worked out man.