> Being real new to MySQL I am having difficulty finding information on how
> retrieve data from the last record in a database.
Mind you - the "last" record doesn't have to be the last record if you're
running an application with multiple users.
That said, the last record in any table using a numeric PK should be the
record with the highest PK value:
order by pk_column desc
> I have tried using the SELECT LAST_INSERT_ID() statement but that only
> on a per connection basis and doesn't help all the times.
> Basically I want to goto the end of file and pull the data from a
> field ("sku") from the last record/row.
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.