Importing CSV's into MySQL(5.6) tables leaves date fields as 0000-00-00
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.