Last Record 1

[Gatorajc]

Can only tell me how I would write a query similar to this one.

SELECT TOP 1 RecordNumber
FROM X
ORDER BY RecordNumber DESC

The query works with SQL Server but it does not seem to work with MySQL.

I want to get the very last record put into the database.

Thanks in advance.



AJ

 

[swampBoogie]

If you want the value generated for an auto_increment column on insert you should use

select last_insert_id()

If you want the highest value in a column

SELECT max(RecordNumber)
FROM X

 

[Gatorajc]

Just what I was looking for



AJ