SQL>Insert and recover the ID
| From: | Christian Ista | Date: | Thu, 31 Oct 2002 21:11:48 +0000 |
| Subject: | SQL>Insert and recover the ID | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-122330@lists.php.net to get a copy of this message | ||
Hello,
In a table, I have some fields and the primary key is an autoincrement
field. I insert an row and I'd like to recover the ID used for the last
record I inserted.
For the moment, I do a select max(Id) just after the insert but there
is, my be a best way to do it.
Thanks for your help
Christian,