title: Warnings on 'LOAD DATA INFILE' from .CSV - Integers and Dates
body: <p>This is probably a pretty simple issue but for the life of me I don't see what I am missing when I try to import this CSV file into my SQL table.</p>
  
  <p>I keep ending up with my int 'idRefs' with 0s, and my date 'dob' as all 12 31 1969</p>
  
  <hr>
  
  <p>Examples of the warnings:</p>
  
  <pre><code>| Warning | 1366 | Incorrect integer value: '
  10002' for column 'idRef' at row 1  |
  | Warning | 1265 | Data truncated for column 'dob' at row 1 
  </code></pre>
  
  <p>The LOAD DATA INFILE statement --</p>
  
  <pre><code>mysql&gt; LOAD DATA INFILE '/home/user/Documents/pplList.csv' INTO TABLE people 
  FIELDS TERMINATED BY ',' LINES TERMINATED BY '"' IGNORE 1 LINES 
  (idRef, lastName, firstName, dob, rsNum, slNum, firstVisit, pplPref, coachName);
  </code></pre>
  
  <p>Just some examples from the CSV --</p>
  
  <pre><code>idRef,lastName,firstName,dob,rsNum,slNum,firstAppt,pplPref,coachName"
  10001,BlankA,NameA,4/15/68,1000000,4600000,3/31/08,Positive,John Jay"
  10002,BlankB,NameB,10/28/78,1000001,4600001,8/19/11,Positive,John Jay"
  </code></pre>
  
  <p>The 'people' table SQL code --</p>
  
  <pre><code>DROP TABLE IF EXISTS people;
  CREATE TABLE people
  (
  id   smallint unsigned NOT NULL auto_increment,
  idRef   int unsigned NOT NULL,
  lastName    varchar(255), 
  firstName   varchar(255),
  dob   date NOT NULL,
  rsNum   int unsigned NOT NULL,
  slNum   int unsigned NOT NULL,
  firstAppt   date NOT NULL,
  pplPref   varchar(255),
  coachName   varchar(255),
  PRIMARY KEY   (id)
  );
  </code></pre>