[thelist] Odd Behavior last night with MySQL Server

Sarah Sweeney mr.sanders at designshift.com
Fri Aug 6 09:18:01 CDT 2004


> 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 "1444" skips to "1638," when there are in fact normal rows just
> like this. Feel free to look at the csv file and see if you see anything
> wrong:
> 
> http://www.azuritedesign2.com/One-Fourth/test.csv
> 
> 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? Then why am I missing 395 rows of
> data? in different places? Only 1708 get inserted.
> 
> Is there a bug in MySQL?

Make sure that when you generate the insert queries, you double-up any 
single quotes in the field values. (Line 215, for example, has one.)

-- 
Sarah Sweeney
Portfolio     http://sarah.designshift.com
Blog          http://hardedge.ca


More information about the thelist mailing list