Max ID

[buddybuddha]

Is there a quick way to tell what the maximum value for the id column is in a mysql db?

 

[MasterB]

SELECT `id` FROM `table_name` ORDER BY `id` DESC LIMIT 0,1

That will retrieve the very last column with only the `id` field returned. Then, depending on what language you are using, get the result of that. I don't know of any quicker ways though. (I havn't error checked that, :bah: )

 

[buddybuddha]

Thanks!

 

[Kate]

SELECT max(id) FROM table_name