A much gentler solution with myql would be:
my $in_id = $dbh->{ q{mysql_insertid}};

and it works...

He clearly knows your suggestion is possible, faf, he mentions it in his opening sentence. The whole point of his post is to show people how to actually use the function, in what he proposes is a DB independent way.
Please, for the love of God, read before you write.

Thanks ... this saved me alot of time!

Ditto, thanks for this blog post, this helped me figure out the last_insert_id function which isn't made very clear in the docs.

Thanks. Such a simple and useful function, yet a pain to search for!

guys..things are worked out..! thanks

Although his use of last_insert_id. If you start delving into the PODs and old mailinglists, you'll find out that last_insert_id() although portable, is less reliable than using something driver specific, eg $dbh->{'mysql_insert_id'}.

The one upside is that this isn't deprecated. officially, funcs like last insert id are very much Database dependent, and the onus is actually on the individual DBD authors to maintain exposure of these things.

Thanks bro...
i gone through many other sites but ur solution worked.U saved my lots of time :)