my @values = (); while($whatever){ my $value = $got_from_somewhere; push @values, $value; } my $query = "INSERT INTO somewhere VALUES ("; $query .= join(" ,", @values); $query .= ")";