I want to import a text file into a table that has a date type column with mysqlimport. In the text file the date column is in the DD-MMM-YY format (ie 25-JUL-02); so when I import it, I get 0000-00-00 in the table's date column. Is there a way to do this correctly ? My version is 3.23.52. Thank you. ###########################################
Disclaimer on Exchange This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php