Or maybe you can just use

my $sql = 'INSERT INTO table2
           SELECT * FROM table1';
my $count = $dbh->do($sql);
print "$count records inserted from table1 into table2\n";
[download]