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
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 | specie
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