On Thursday, May 16, 2002, at 01:55 PM, Kevin O wrote:
> 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.
this will economically generate your string.
whether it is meta-economic i don't know:
$vals = "?, " x 500;
> Any help is appreciated,
> Kevin
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
