NULL values from LOAD DATA infile

2004-11-08 Thread 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 | i

advantages mysqldump -T option

2002-06-24 Thread Rachael LaPorte Taylor (SSD)
g the -T option? -- Rachael LaPorte Taylor Senior Technology Architect, FedStats U.S. Census Bureau Washington DC 20233 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual)