Mysql: Load text file with date field

[Anon]

Hi,

I need to load data from a text file into a table in mysql. Some fields are dates and these are in the format DD.MM.YYYY. I used the load data command to do this, but the date field comes out as 0000-00-00 because the mysql date format is different. All the other fields are loaded correctly. How can I load data with different date formats correctly into the table? Do I have to convert the dates into the correct format first? I hope someone can help me out on this. Thanks.

regards,
CY

[[deleted]]

You can either change the data from the textfile into the correct format, or you can create an extra string column in your table, into which you load the wrong format date.
You can then use an UPDATE statement to pull the data from the new column and store it in the correct format into the date column.

You'll have to find out for yourself which is easier/fastest.