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
I'm trying to import a file using LOAD DATA INFILE into a table
containing columns that default to NULL. However, values load into the
table as 0 (zeros). What can I do to have these default to NULL?
mysql> describe table column;
Field | Type | Null | Key | Default | Extra |
column | i
