I am at my wits end. I have written this query which is aimed at importing my csv data uinto mysql table 'refs'
load data local infile '/home/amaina/Documents/march2016.csv' into table refs fields terminated by ',' enclosed by '"' escaped by '' lines terminated by '\n' ignore 1 rows;
My pain is that whenever i run this query i get the following results:
Query OK, 0 rows affected, 33 warnings (0.00 sec)
Records: 11 Deleted: 0 Skipped: 11 Warnings: 33
The CSV file looks something like this (attached) i changed it to .txt for it to be uploaded
What can be possibly be doing wrong. I have been splitting hairs for the past 6 hours