Bug #13805 import numeric fields with missing data
| Submitted: | 6 Oct 2005 14:52 | Modified: | 6 Oct 2005 17:41 |
|---|---|---|---|
| Reporter: | Sylvain Smith | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | OS: | ||
| Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[6 Oct 2005 14:52]
Sylvain Smith
[6 Oct 2005 17:41]
MySQL Verification Team
I think this problem isn't with the server and instead how the data file was created. Please see: http://dev.mysql.com/doc/mysql/en/problems-with-null.html When reading data with LOAD DATA INFILE, empty or missing columns are updated with ''. If you want a NULL value in a column, you should use \N in the data file. The literal word “NULL” may also be used under some circumstances. See Section 13.2.5, “LOAD DATA INFILE Syntax”.
[7 Oct 2005 7:00]
Sylvain Smith
Thank you very much for your answer. I tried to replace '' with \N and the fields in the database were correctly replaced by Null values. Thank you again.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.