Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: perl mysql - INSERT INTO, 157 columns

by kschwab (Priest)
on May 02, 2014 at 16:59 UTC ( #1084813=note: print w/replies, xml ) Need Help??


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.

  • Comment on Re: perl mysql - INSERT INTO, 157 columns

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1084813]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2018-05-28 02:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?