Inserting Multiple values

[Kipp, James]

Hello

I am quite new to DBI and I am learning from the Perl DBI Book. It does not
cover inserting data in detail. I am just wondering the best way to insert
many values into a field. I know it is something like:

$dbh->prepare( "INSERT INTO tbl_people ( lastname ) VALUES (?)" );

How do I have it iterate through an array of names ?

foreach $name (qw( Smith Jones Roberts Johsnon Fredericks) ) {
        sth->execute($name);
}

Thank You