I would first suggest taking another look at your table design.
Having 500 columns in a table is most likely not a thing you
really want to do.
But if you must, then yes you will have to put in 500 ?'s into
your prepare.
---------------------------------
Frank Wiles <[EMAIL PROTECTED]>
Revolution Systems, LLC.
---------------------------------
On Thu, 16 May 2002 15:55:29 -0500 "Kevin O" <[EMAIL PROTECTED]> 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.
>
> 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]
