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