List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 30 1999 1:07am
Subject:Re: LOAD DATA puts NULL into NOT NULL key
View as plain text  
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/
Thread
LOAD DATA puts NULL into NOT NULL keysullivan30 Jun
  • LOAD DATA puts NULL into NOT NULL keyMichael Widenius30 Jun
  • Re: LOAD DATA puts NULL into NOT NULL keyPaul DuBois30 Jun
Re: LOAD DATA puts NULL into NOT NULL keySteve Sullivan30 Jun