in reply to Re: How do I find what column $dbh-{'insert_id'} was inserted into?
in thread How do I find what column $dbh-{'insert_id'} was inserted into?

The function you need is LAST_INSERT_ID().
I think this is particular to MySQL. For Sybase and Oracle, also try
SELECT @@IDENTITY FROM table

[download]
My projects have always had this statement in a transaction, but I'm not sure if it's needed.
  • Comment on Re: Re: How do I find what column $dbh-{'insert_id'} was inserted into?
  • Download Code

In Section Seekers of Perl Wisdom