Import CSV file with blank Date field
I am trying to import a .csv file into a table. This is being done through MySQL Workbench where I right click on the table and use the Table Data Import Wizard.
I have a date field that may or may not have a date in the .csv file. I have tried ,, ,\N, ,NULL, and ,null, but I always get an error if there is not actual date.
Subject
Views
Written By
Posted
Import CSV file with blank Date field
6761
October 03, 2018 08:12AM
3069
October 03, 2018 09:20AM
3050
October 03, 2018 10:32AM
2555
October 03, 2018 11:32AM
2717
October 03, 2018 10:48PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.