Hello all,
I need to insert a lot of data into a mysql table. Know that I can do it
like this example:
my $sth = $dbh->prepare(q{
INSERT INTO sales (product_code, qty, price) VALUES (?, ?, ?)
}) or die $dbh->errstr;
while (<>) {
chomp;
my ($product_code, $qty, $price) = split /,/;
$sth->execute($product_code, $qty, $price) or die $dbh->errstr;
}
$dbh->commit or die $dbh->errstr;
My problem is, I have 500 fields. I know I can start the Insert statement
like INSERT INTO mytable VALUES - cause I'm inserting a value for every
field in the database, but do I have to type a "?" for all 500 fields? BTW,
I'm just feeding execute with an array of values, like above.
Any help is appreciated,
Kevin
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
