[thelist] Odd Behavior last night with MySQL Server

[Wes Reed]

I retract my previous hasty red-herring comment.  Hassan is right about the 
number of columns.

Wes

At 08:03 AM 8/6/2004, you wrote:
>Rob Smith wrote:
>
>>These are the INSERT commands generated by the above script:
>>http://www.azuritedesign2.com/One-Fourth/importdata.php
>>It all looks like it should work right?
>
>No. The format of the INSERT command you're using requires a value
>*for each column of the table*.
>
>>Ok. There are 2103 rows like this in my csv file. I've (now) confirmed that
>>5 times. Yet when I run the above script, it will sporadically skip large
>>amounts of rows?! In one particular case it will go from "429" skips to
>>"519"
>
>And there's an obvious clue -- entry 429 has 6 fields, 430 has only
>5. Too bad PHP apparently doesn't bother to pass back error messages
>(or stop entirely on error) or you'd have discovered this as soon as
>you hit item 35.  :-)
>
>HTH!
>
>P.S. you can use LOAD DATA INFILE to bypass this issue entirely...
>--
>Hassan Schroeder ----------------------------- hassan at webtuitive.com
>Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com
>
>                           dream.  code.
>
>
>--
>* * Please support the community that supports you.  * *
>http://evolt.org/help_support_evolt/
>
>For unsubscribe and other options, including the Tip Harvester and 
>archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !