Reading Date from a csv file

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

RE: Reading Date from a csv file

Try '-mm-dd'. -Original Message- From: Lakshmi Chennareddi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:18 AM To: [EMAIL PROTECTED] Subject: Reading Date from a csv file I am new to mySQL. I am trying to import data from a csv file, using the following code LOAD

Re: Reading Date from a csv file

try ISO standard dates MMDD - Original Message - From: Lakshmi Chennareddi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 4:17 PM Subject: Reading Date from a csv file : I am new to mySQL. : : I am trying to import data from a csv file, using