laziness, impatience, and hubris | |
PerlMonks |
Re: perl mysql - INSERT INTO, 157 columnsby kschwab (Vicar) |
on May 02, 2014 at 16:59 UTC ( [id://1084813]=note: print w/replies, xml ) | Need Help?? |
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.
In Section
Seekers of Perl Wisdom
|
|