Hello Shreyak,

As everybody suggested, I think there might be a really small syntax mistake at your code. Provide us with a short script to take a closer look.

By the way I found this piece of code:

$dbh->do('INSERT INTO a_table ...');
my $id = $dbh->last_insert_id(undef, undef, qw(a_table a_table_id))
    or die "no insert id?";
[download]

Taken from MySQL Perl DBI last_insert_id. Take a look, maybe you will see a difference on your syntax.

Forgot to mention that also SELECT LAST_INSERT_ID() the MySQL query will also do the job. You can read more about it here LAST_INSERT_ID(), LAST_INSERT_ID(expr).

Hope this helps.