Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

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 the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (6)
As of 2018-09-21 11:32 GMT
Find Nodes?
    Voting Booth?
    Eventually, "covfefe" will come to mean:

    Results (185 votes). Check out past polls.

    • (Sep 10, 2018 at 22:53 UTC) Welcome new users!