this should work....
SELECT sku from [table] order by [key] desc limit 1
<JHunter@SPFLDSPA To: mysql@stripped
Subject: Finding information in the last
Being real new to MySQL I am having difficulty finding information on how
retrieve data from the last record in a database.
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.
If anyone could point me in the right direction I would appreciate it
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/03
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1