MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

Re: Importing CSV with NULL values to a Table
Posted by: Marcin Szalowicz
Date: July 20, 2018 06:35AM

Hello Kenneth

Please try to remove the NULL text and instead leave it just empty so
this: ,NULL, will become ,,

Marcin Szałowicz, MySQL Developer Tools
Oracle Corporation

Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/5.6/en/index.html

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


Subject
Views
Written By
Posted
Importing CSV with NULL values to a Table
20292
kenneth dyson
June 05, 2018 11:17AM
Re: Importing CSV with NULL values to a Table
6789
kenneth dyson
June 08, 2018 12:06PM
Re: Importing CSV with NULL values to a Table
5702
Marcin Szalowicz
July 20, 2018 06:35AM
Re: Importing CSV with NULL values to a Table
4436
Krishna Kumar
August 11, 2018 03:36AM
Re: Empty cells in csv file are dropped when imported into mysql
3763
ridth rahman
April 02, 2019 12:55PM
Re: Importing CSV with NULL values to a Table
2506
Jack Maughan
August 08, 2019 08:40PM


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.