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
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