How to return all fields when using MAX() function in MySQL?

[mejar sing]

select max(id)
from user

it produces one field, which is what I don't want; I want
complete one row with(id,name, address)

[brettl]

You have to use:

SELECT max(id), name, address FROM user GROUP BY "some other field that makes sense"
 

Hope that helps

[Atli]

Hi Mejar. Welcome to TSDN!

Brettl is almost right. The first part of his query will give you what you need:

SELECT max(id), name, address FROM user
 

Or, if you don't know how many fields there are:

SELECT max(id), * FROM user
 

P.S.
I've moved your thread over to the MySQL Forums and re-named it to better describe it's contents.
Please try to post your threads in the appropriate forum and give it a descriptive title.

Take a look at our Posting Guidelines for more info on our posting policies and hints on what makes a good thread title.

[mwasif]

If you want to get the results related to that maximum id then use ORDER BY e.g.

SELECT id, name, address FROM user ORDER BY id DESC LIMIT 1;