MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

Re: Import CSV file with blank Date field
Posted by: Doug Lundin
Date: October 03, 2018 10:32AM

MySQL 8.0

- Row import failed with error: ("Incorrect date value: '\\N' for column 'BirthDate' at row 1", 1292)

sql_mode does not have ALLOW_INVALID_DATES

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Import CSV file with blank Date field
6842
Doug Lundin
October 03, 2018 08:12AM
Re: Import CSV file with blank Date field
3110
Peter Brawley
October 03, 2018 09:20AM
Re: Import CSV file with blank Date field
3086
Doug Lundin
October 03, 2018 10:32AM
Re: Import CSV file with blank Date field
2584
Doug Lundin
October 03, 2018 11:32AM
Re: Import CSV file with blank Date field
2743
Peter Brawley
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.