my @name=("Anna","Maria","Carmen");
my @age=("25","27","29");
my @eyes=("brown","blue","pink");
#those arrays have always the same number of elements
for (my $i=0;$i<=$#name;$i++){
my $sth=$dbh->prepare(qq{UPDATE tnt SET `Age`=\"$age[$i]\",`Eyes`=\"$eyes[$i]\" WHERE `Name`=\"$name[$i]\"});
$sth->execute();
}
$sth->finish;
####
Name Age Eyes
Corina 13 red
Ada 17 blue
Anna 10 grey
Maria 2 white
Carmen 6
####
Anna 25 brown
Maria 27 blue
Carmen 29 pink