In article <098B772B00EA5D4E9E9F3EEA736F0692043A9B4B@stripped>,
"Barbara Deaton" <Barbara.Deaton@stripped> 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 '...'"?
