my $sth_insert = $dbh2->prepare("insert into back_table_2 (abc1,abc2,abc3) VALUES (?, ?, ?) "); while ($row = $sth->fetchrow_arrayref) { $sth_insert->execute(@$row); }