The biggest value in ID field

[joon]

ID is primary key an auto_incremented in myTable.

I like to find the ID value of the last record currently.

select ID
from myTable
where THE MOST LARGEST NUMBER IN ID FIELD

Thanks in Advance

[Nate]

SELECT max(ID)
FROM myTable

or

SELECT ID
FROM myTable
ORDER BY ID
DESC
LIMIT 1

[joon]

Thanks

[Sxooter]

Note that unless you do this in a transaction, it's open to race conditions:

USER1: id = select max(id) from table;
USER2: Insert into table (field1) values ('abc');
USER1: insert into table (autoinc, field1) values (id+1,'def');

Now you'll get a failure since you're trying to insert a record with the same id as already inserted by user 2.