Reading Date from a csv file

[Lakshmi Chennareddi]

I am new to mySQL.

I am trying to import data from a csv file, using the following code

LOAD DATA LOCAL INFILE 'D:/foldername/file1.csv' 

    INTO TABLE database_name.tbl_name   

    FIELDS TERMINATED BY ',' 

              (

        field1,

       field6_date,

        field9

               );

 

The data is getting imported, but the dates are wrong. 

In the original data file the dates are "mm/dd/yy" format. How do I specify
the date formats, in the code?

 

Thanks in advance for any help,

Lakshmi