NULL values from LOAD DATA infile

[Rachael LaPorte Taylor]

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  | int(11) | YES  |        | NULL  |       |
I've tried inserting both NULL and undef into records in the infile 
(fields delimited by commas):

45156,NULL,NULL,NULL,NULL
45156,,,,
---
Rachael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]