in reply to DBI insert: Need to retrieve an autoincremented column from a table after an insert.

DBI has last_insert_id but be sure to read all the notes about portability and such. I'm no dba but I believe the dilemma is that there's no real standard for such a query.

Edit: Oops, you already mentioned that. Sorry, I didn't read your post closely enough. I'm afraid you'll probably need to get into something more driver specific. As Anon mentioned, PostgreSQL has a native way to get an id, and so do some (most?) other databases.

  • Comment on Re: DBI insert: Need to retrieve an autoincremented column from a table after an insert.
  • Download Code

In Section Seekers of Perl Wisdom