in reply to Not able to insert data in mysql

I think you forgot: $dbh->commit

In Section Seekers of Perl Wisdom