my $sql = "insert into recherche (ort, mv_id, mol_id, ...) values (?,?,?,?)"; my $sth = $dbh->prepare($sql) or die $dbh->errstr(); $sth->execute(@params{qw/ort mv_id mol_id/}) or die $dbh->errstr();