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
How do you convert a date dd/mm/ from a .txt file
into mysql date
format when using LOAD DATA INFILE ?
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archiv
