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

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.
  • Comment on Re^3: perl mysql - INSERT INTO, 157 columns