in reply to perl mysql - INSERT INTO, 157 columns
Other answers here cover your main question well. I thought, though, that it might be helpful to point out that MySql has a hardcoded limit of 65,336 bytes per row.
The limit doesn't apply to TEXT and BLOB columns in the row, but with 157 columns, it wouldn't take too many large varchars to blow the limit.
You might want to consider some normalization for this, and other reasons.
|
|---|