Blanchard [mailto:[EMAIL PROTECTED]
Sent: maandag 4 augustus 2003 14:08
To: Andre Winarko; [EMAIL PROTECTED]
Subject: RE: Convert date from .txt file
[snip]
How do you convert a date dd/mm/ from a .txt file
into mysql date
format when using LOAD DATA INFILE ?
[/snip]
LOAD DATA INFILE cannot
[snip]
How do you convert a date dd/mm/ from a .txt file
into mysql date
format when using LOAD DATA INFILE ?
[/snip]
LOAD DATA INFILE cannot do the conversion "on-the-fly". You could use a
scripting language (sed, awk,etc.) to read and convert the dates.
HTH!
--
MySQL General Mailing List
