Hi,
I have a CSV-file exported from another database.
It contains fields with dates and dates and times. A somplefied CSV-file version looks
like so.
20.12.1999;21.12.1999 03:35:27
When I import it with LOAD DATA INFILE... and use fieldtypes "date" and "datetime" it
sadly does not work. It imports as many records as lines are given in the file to
import but each date is zero (NULL). Is there a possibility to import it that "simple"
way rather to import it as text in one table and export it using date
conversion-functions in another table?
Best Regards
Bernhard Dobler
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
