Importing CSV's into MySQL(5.6) tables leaves date fields as 0000-00-00 During the import from a CSV file created from an MS Access table into a MySQL table it converts all date fields in the csv into  0000-00-00. I use the following Load Data command for the import.

LOAD DATA LOCAL INFILE 'C:\\..\\tableName.txt'
INTO TABLE tableName
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';


Here's an example line from the CSV file im trying to import.

1,1,5/30/1934 0:00:00,"H","Vancouver, B.C."....

I tried the solution from "Dates changed to 0000-00-00" but it didn't work.
You can import your .csv file and replace after:


Make your date column new_date_column VARCHAR(10).
Import the file.
UPDATE with REPLACE.



  UPDATE db1.table1
   SET  new_date_column = STR_TO_DATE(REPLACE(new_date_column,'/','.'),GET_FORMAT(DATE,'EUR'));



Change the datatype of new_date_column.


ALTER TABLE db1.table1 MODIFY new_date_column new_date_column DATE;

This will convert your new_date_column into XXXX-XX-XX date format.