At 6:05 PM -0700 6/29/1999, sullivan@stripped wrote:
>>Description:
>
>Hi - This may be a silly question, but it looks like
>LOAD DATA will load \N into a "NOT NULL" key.
>How can I prevent this?
>
>>How-To-Repeat:
>
>
>
>Here's an example:
>
>create table quesa (
> ident VARCHAR(255) NOT NULL,
> size INT,
> PRIMARY KEY( ident));
>
>load data local infile "quesa.txt" into table quesa;
>
>========= quesa.txt file contents: ===========
>alpha 10
>\N 20
>gamma 30
>========= end file =======================
>
>It replies ...
>Records: 3 Deleted: 0 Skipped: 0 Warnings: 1
>
>select * from quesa;
>+-------+------+
>| ident | size |
>+-------+------+
>| alpha | 10 |
>| | 20 |
>| gamma | 30 |
>+-------+------+
>3 rows in set (0.00 sec)
I don't see a NULL, I see an empty string. Not the same thing.
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
