Rachael LaPorte Taylor wrote:
I'm trying to import a file using LOAD DATA INFILE into a table containing columns that default to NULL.
See http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html :
| Handling of NULL values varies according to the FIELDS and LINES options in use:
|
| * For the default FIELDS and LINES values, NULL is written as a field value of \N for output, and a field
| value of \N is read as NULL for input (assuming that the ESCAPED BY character is `\').
| * If FIELDS ENCLOSED BY is not empty, a field containing the literal word NULL as its value is read as
| a NULL value. This differs from the word NULL enclosed within FIELDS ENCLOSED BY characters,
| which is read as the string 'NULL'.
| * If FIELDS ESCAPED BY is empty, NULL is written as the word NULL.
| * With fixed-row format (which happens when FIELDS TERMINATED BY and FIELDS ENCLOSED BY
| are both empty), NULL is written as an empty string. Note that this causes both NULL values and
| empty strings in the table to be indistinguishable when written to the file because they are both
| written as empty strings. If you need to be able to tell the two apart when reading the file back in, you
| should not use fixed-row format.
-- Keith Ivey <[EMAIL PROTECTED]> Washington, DC
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
