MySQL Forums
Forum List  »  MySQL Workbench

Import CSV file with blank Date field
Posted by: Doug Lundin
Date: October 03, 2018 08:12AM

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.

Options: ReplyQuote

Written By
Import CSV file with blank Date field
October 03, 2018 08:12AM

Sorry, only registered users may post in this forum.

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.