this should work.... SELECT sku from [table] order by [key] desc limit 1
hth
Jeff
"Hunter, Jess"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
RC.ORG> cc:
Subject: Finding information in the
last record
10/29/2003 10:50
AM
Being real new to MySQL I am having difficulty finding information on how
to
retrieve data from the last record in a database.
I have tried using the SELECT LAST_INSERT_ID() statement but that only
works
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
particular
field ("sku") from the last record/row.
If anyone could point me in the right direction I would appreciate it
Jess
---
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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
