This worked for me: create table tblZips( id int unsigned not null auto_increment primary key, city char(24) not null default '', state char(2) not null default '', zip char(5) not null default '' ) Type=InnoDB;
Saved CSV file as a UNIX (instad of DOS format file) LOAD DATA INFILE 'zips.csv' INTO TABLE tblZips FIELDS TERMINATED BY ',' ENCLOSED BY '\'' LINES TERMINATED BY '\n' (city,state,zip); Query OK, 41943 rows affected (3.86 sec) Records: 41943 Deleted: 0 Skipped: 0 Warnings: 0 mysql> select min(id) AS first, max(id) AS last, count(id) as total FROM tblZips; +-------+-------+-------+ | first | last | total | +-------+-------+-------+ | 20973 | 62915 | 41943 | +-------+-------+-------+ --------------------- Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -----Original Message----- From: Sean O'Donnell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 5:00 PM To: MySQLMailingList Subject: LOAD DATA LOCAL INFILE (Only loads 20,000 or 41,000 Records) 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 --------------------------------------------------------------------- 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
