note
Neighbour
<p>It might have been mentioned here before, but I'll put it as explicitly as possible:</p>
<p>
There were 2 errors, the first error you fixed yourself by making sure that <c>`Symbol`,`Company_Name`,`Last_Price`,...,`Mktcap`</c> had the same amount of items as the amount of ?'s in your VALUES-list.</p>
<p>The second error means that mysql now expects values when you execute your query (<c>$sth->execute(@h);</c>). Apparently, your <c>@h</c> contains only 29 values, but there are 43 ?'s that need to be given something (a value or 'undef' if you want it to be NULL).</p>
<p>If you want to fill all the extra columns (that you initially added all those ?'s for) to be NULL, why don't you just do that in your query?</p>
918140
918140