Re^2: perl mysql - INSERT INTO, 157 columns

in reply to Re: perl mysql - INSERT INTO, 157 columns
in thread perl mysql - INSERT INTO, 157 columns

Would I still need to list all of the column names?

my $placeholders = join ", ", ("?") x @array;
$sth->prepare("insert into bigtable (col...) values ($placeholders)");
$sth->execute(@array);
[download]

Comment on Re^2: perl mysql - INSERT INTO, 157 columns Download Code

Replies are listed 'Best First'.
Re^3: perl mysql - INSERT INTO, 157 columns by Anonymous Monk on May 01, 2014 at 21:13 UTC
From here: If you do not specify a list of column names for INSERT ... VALUES or INSERT ... SELECT, values for every column in the table must be provided by the VALUES list or the SELECT statement.	[reply]

In Section Seekers of Perl Wisdom