his is my first post here so please excuse any irrelevancies. I am trying to load a .csv file that contains 41943 Records of Data. I am only able to load 20972 Records. (it seems to skip almost every-other record).
The file, located @: http://thisLinux.kicks-Ass.net/projects/databases/tbl_mapZipCodes.csv and contains 41943 lines that match the following comma-seperated structure: 'Pleasantville','NY','00401' 'Holtsville','NY','00501' 'Holtsville','NY','00544' Here is my query >> mysql> LOAD DATA LOCAL INFILE '/usr/local/httpd/htdocs/projects/databases/tbl_ma -> INTO TABLE RecruiterConsole.tbl_mapZipCodes -> FIELDS TERMINATED BY ',' -> OPTIONALLY ENCLOSED BY '\'' -> LINES TERMINATED BY '\n' -> (mapCity,mapState,mapZip); Here are the Results >> Query OK, 20972 rows affected (1.56 sec) Records: 20972 Deleted: 0 Skipped: 0 Warnings: 41943 I have tried a few different trouble-shooting scenarios and none seem to work for me. Anybody have any suggestions or similar experiences? Thanks in advance. Sean O'Donnell Monrovia, CA. [EMAIL PROTECTED] http://dynamicwebdevelopers.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
