Hi,
I'm using version 3.23.49 on RH7.3.
I'm following the menagerie example and have added some lines to the
pet tabel using the LOAD DATA LOCAL INFILE... construction.
I have created a file pet.txt like the manual suggests and have added \N
in some fields to include NULL values.
However when
On 28 Aug 2002, at 19:49, Mertens Bram wrote:
Here are a few lines from the pet.txt:
flufyyharold cat f 1993-02-04 \n
Chirpy\n bird\n \n \n
[snip]
What am I doing wrong?
Not paying attention to case. As you said earlier, the code for
In addition to my previous post, if I use the INSERT command like:
mysql INSERT INTO pet VALUES ('bark',NULL,'dog','m','2000-01-30',NULL);
the NULL values are entered correctly:
mysql SELECT * FROM pet;
+--++-+--+++
| name | owner | species
On Wed, 2002-08-28 at 21:17, Keith C. Ivey wrote:
Not paying attention to case. As you said earlier, the code for NULL
is \N, not \n.
Oh my! I feel so stupid! I should have known to check the case better by now.
\n is a newline in mysql, right? That's probably why the lines are 'broken' in