getting last value from a column?

[Vivid Lust]

Hey, say I had this table;

 

id  foo

1      a

2      a

3      a

4      a

5      a

6      a

7      a

 

How can I get the last value of the id column??? (7)

 

Thanks for your help!

[rhodesa]

SELECT * FROM tableName ORDER BY id DESC LIMIT 1

[fenway]

Depends what you mean by "last"... MAX(id) works too... but I prefer to have a timestamp to sort by.

[rhodesa]

i guess i was assuming ID was an auto_increment value...