At 21:39 -0400 10/14/06, Ferindo Middleton wrote:
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date
Subject: change format of date fields during LOAD DATA INFILE?
Is there a way to change the format of date fields MySQL is
expecting when
LOADing data from a file? I have no problem with the format
MySQL saves the
date but most spreadsheet programs I use don't make it easy
to export text
-Original Message-
From: Ferindo Middleton [mailto:[EMAIL PROTECTED] ]
Sent: Saturday, October 14, 2006 9:40 PM
To: mysql
Subject: change format of date fields during LOAD DATA INFILE?
Is there a way to change the format of date fields MySQL is
expecting when
LOADing data from a file
At 08:39 PM 10/14/2006, Ferindo Middleton wrote:
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date fields in the format -MM-DD even if I formated the