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.
I keep ending up with my int 'idRefs' with 0s, and my date 'dob' as all 12 31 1969
Examples of the warnings:
| Warning | 1366 | Incorrect integer value: '
10002' for column 'idRef' at row 1 |
| Warning | 1265 | Data truncated for column 'dob' at row 1
The LOAD DATA INFILE statement --
mysql> 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);
Just some examples from the CSV --
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"
The 'people' table SQL 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)
);
