[snip] How do you convert a date dd/mm/yyyy 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 For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]