In article <[EMAIL PROTECTED]>, "Barbara Deaton" <[EMAIL PROTECTED]> writes:
> Thank you for the idea. It fixed my date problem, but my numeric column is > still 0 and NOT "NULL." Here's what I did: > create table a ( > d date default null, > e smallint default null ); > CREATE TEMPORARY TABLE tmp ( > d TEXT not NULL, > e TEXT not NULL ); > LOAD DATA LOCAL INFILE "c:\\temp\\mysql.txt" > INTO TABLE tmp > FIELDS TERMINATED BY ',' > IGNORE 1 LINES; > INSERT INTO a (d, e) > SELECT CASE d WHEN '' THEN NULL ELSE d END, > CASE e WHEN '' THEN NULL ELSE e END > FROM tmp; mysql> select * from a; > +------------+------+ > | d | e | > +------------+------+ > | 2005-12-31 | 0 | > | NULL | 2 | > +------------+------+ > Is there anything else I can do? This works fine for me, but fortunately I don't use Windoze. Perhaps you need to mess with "LOAD DATE ... LINES TERMINATED BY '...'"? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
