title: CSV file import errors in to Mysql Workbench 6.3
body: <p>I'm new to Mysql and am using it to make use of several CSV files I have that are very large (some have over a million rows). I'm on Win7-64 Ultimate. I have installed MySql Workbench v. 6.3.6 build 511 64 bit. I read a similar question however I cannot comment since I am new. I am getting a different error anyway.</p>
  
  <p>I have set up a database called crash0715, and created a table called driver_old with five columns. The first column is a report number (set up as INT(20)) that will be keyed to other files. It contains some duplicates depending upon the data in the other columns. The next four columns contain numeric data that is either 1 or 2 digits.</p>
  
  <p>I set up the report_number column as INT(20), primary key, not null.
  The other 4 were set up as INT or INT(2)</p>
  
  <p>When I tried to import a little over 1 million rows in a 5-column CSV file (named do.csv in my c:\ root) via the GUI, the program hung. I had let it run over 12 hours and my task manager showed the program was using 25% cpu.</p>
  
  <p>I next tried the command line. After switching to the database, I used 
      LOAD DATA LOCAL INFILE  'c:/do.csv' INTO TABLE driver_old FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';</p>
  
  <p>I had removed the header row from the CSV before trying both imports.</p>
  
  <p>I got the following message:
      QUERY OK, 111 rows affected, 65535 warnings &lt;3.97 sec> Records: 1070145 Deleted: 0 Skipped: 1070034 Warnings: 2273755</p>
  
  <p>I read the first few lines of SHOW WARNINGS and they were as follows:
  1264 Out of range value for column 'report_number' for row 1.
  1261 Row 1 doesn't contain data for all columns</p>
  
  <p>These two repeated for all of the other lines.</p>
  
  <p>There was also a 
  1062 Duplicate entry '123456789' for key 'primary' (123456789 is a representative value)</p>
  
  <p>It also reoccurred with the other two codes.</p>
  
  <p>The CSV file has no blanks on the first column, however there are a few in the other ones.</p>
  
  <p>Any idea what I'm doing wrong here?</p>