my $ext_insert = $dbh3->prepare("INSERT IGNORE INTO $feed_table_ext (id_code, item_name, item_value, item_data) VALUES (?, ?, ?, ?)") or die $dbh3->errstr; while (my @insert_ext = $feed_table_ext_results->fetchrow_array()) { $ext_insert->execute(@insert_ext) or die $sth_insert->errstr; }