[Resolved] Select entire row based on MAX value

[cbj4074]

This is bugging the hell out of me...

It should be so simple. I have a MySQL table and several columns, each of which stores various information (not important).

There is an auto-increment index column.

I just want to select the entire row that was added most recently (i.e. the row that has the highest auto-increment value).

I can't seem to find or figure out how to select the entire row using the MAX() function.

When I do:

SELECT max(id) from retailers

I only get that one cell, with the auto-increment value (the ID, in this case), and not the rest of the row. How can I get the whole row without doing two queries?

Thanks - I know I'll feel dumb on this one.

[travelbuff]

Try this:

SELECT * from retailers ORDER BY id desc LIMIT 1

may not be super efficient on large tables but it should work fine since ID is bound to have an index.

[cbj4074]

That does indeed work okay, thank you for the suggestion, travelbuff.