Is it possible to import a CSV file containing a date field which can have null values into a MySQL database? Using an empty field, ‘null’ or ‘\N’ all generate the error
"Error: ER_TRUNCATED_WRONG_VALUE: Incorrect date value … "
I can put default dates into the CSV file I am developing with at the moment as a work around but this is not a solution for live files.
Community Page
Last updated:
Last updated: