Help for this page
# set up some sample data, assume $#columns == $#values my @columns = qw / Standardisation_type Male_00_04 Female_85_plus /; ... my $sth = $dbh->prepare($sql) or die "Couldn't prepare query"; $sth->execute(@values);
INSERT INTO Standard_population(Standardisation_type,Male_00_04,Female +_85_plus) VALUES (?,?,?)