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