in reply to Re: Re: DBI: last insert id
in thread DBI: last insert id
holds the most recently assigned id. Your code might then be rewritten as$dbh->{mysql_insertid}
my $id = $dbh->{mysql_insertid}; $sth = $dbh->prepare(<<"SQL"); UPDATE history SET history_conf = ? WHERE history_id = ? SQL $sth->execute($id, $id);
|
|---|