Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

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?

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2018-01-20 16:22 GMT
Find Nodes?
    Voting Booth?
    How did you see in the new year?

    Results (227 votes). Check out past polls.