Getting values from row with the largets id

[Frank]

One way that I determine the most recent insertion into a table is to
get the highest id value in the id field. Using the auto increment
function whenever a new record is inserted in the table, the hightest
id number by default is the most recent submission into this table.

I would like to create a query that pulls up all the data from the row
with the highest id number. I know that to get that number, I can use
the max(id) approch, but I don't know how to enter this into a sql
statement, and get the other values that attach to it. I tried "select
name from table where id=max(id) but I get a group error reply.

What can I do to get the values I'm looking for?

Thanks,
Bill

[Aggro]

Frank wrote:

What can I do to get the values I'm looking for?

# Easy way
select name from table order by id desc limit 1;

# or using some programming language:
select max(id) from table;
// Save result id to variable max_id
select name from table where id=max_id;

# or if you have MySQL >= 4.1, you can use subqueries:
select name from table where id in(select max(id) from table);

[Aggro]

Frank wrote:

What can I do to get the values I'm looking for?

# Easy way
select name from table order by id desc limit 1;

# or using some programming language:
select max(id) from table;
// Save result id to variable max_id
select name from table where id=max_id;

# or if you have MySQL >= 4.1, you can use subqueries:
select name from table where id in(select max(id) from table);

[Aggro]

Frank wrote:

What can I do to get the values I'm looking for?

# Easy way
select name from table order by id desc limit 1;

# or using some programming language:
select max(id) from table;
// Save result id to variable max_id
select name from table where id=max_id;

# or if you have MySQL >= 4.1, you can use subqueries:
select name from table where id in(select max(id) from table);