Re: Auto Increment ID of Inserted Row

[Dan Nelson]

In the last episode (Sep 19), Steven Kreuzer said:
> >What is the SQL to get the created AutoInc ID from a row that I have
> >just inserted?
>
> SELECT MAX(id_field) FROM table

Nope.  If someone else inserted a record between the time you inserted
yours and the time you run that select, your answer will be wrong. 
Use LAST_INSERT_ID(), or whatever construct your language provides for
retrieving it without doing another query.

-- 
	Dan Nelson
	dnelson@stripped