DBI & MYSQL (How to receive autoincrement a field after an insert)
For example I insert row into base (MySQL). The first field id - an primary key generate also is inserted itself autoincrement.
As after an insert at once to receive this number for inserting in other table.
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by dema501:
For example I insert row into base (MySQL). The first field id - an primary key generate also is inserted itself autoincrement.
As after an insert at once to receive this number for inserting in other table.[/quote]
Use the LAST_INSERT_ID() function.
- Glen
Maybe it better http://www.devshed.com/Talk/Forums/smile.gif
$dbh->{'mysql_insertid'};