List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:September 17 2001 8:42pm
Subject:Re: Why does example not work?
View as plain text  
At 8:03 PM +0200 9/17/01, Danny Kohn wrote:
>Hi.
>Newbee trying to learn MySQL.
>
>On page 167 in the manual there is an example file that should be 
>loaded into the newly created file event.
>
>The table is:
>+--------+--------------+------+-----+---------+-------+
>| Field  | Type         | Null | Key | Default | Extra |
>+--------+--------------+------+-----+---------+-------+
>| name   | varchar(20)  | YES  |     | NULL    |       |
>| date   | date         | YES  |     | NULL    |       |
>| type   | varchar(15)  | YES  |     | NULL    |       |
>| remark | varchar(255) | YES  |     | NULL    |       |
>+--------+--------------+------+-----+---------+-------+
>
>The file to import is:
>Fluffy	1995-05-15	litter	4 kittens, 3 female, 1 male
>Buffy	1993-06-23	litter	5 puppies, 2 female, 3 male
>Buffy	1994-06-19	litter	3 puppies, 3 female
>Chirpy	1999-03-21	vet	needed beak straightened
>Slim	1997-08-03	vet	broken rib
>Bowser	1991-10-12	kennel	\N
>Fang	1991-10-12	kennel	\N
>Fang	1998-08-28	birthday	Gave him a new chew toy
>Claws	1998-03-17	birthday	Gave him a new flea collar
>Whistler	1998-12-09	birthday	First birthday
>
>The command to import is
>
>LOAD DATA LOCAL INFILE "d:/Program/MySQL/data/menagerie/event.txt" 
>INTO TABLE event;
>
>But select * from event; gives the following very strange result:
>+----------+------------+----------+------------------------------+
>| name     | date       | type     | remark                       |
>+----------+------------+----------+------------------------------+
>  |Fluffy   | 1995-05-15 | litter   | 4 kittens, 3 female, 1 male
>  |Buffy    | 1993-06-23 | litter   | 5 puppies, 2 female, 3 male
>          | | 1994-06-19 | litter   | 3 puppies, 3 female
>     |rpy   | 1999-03-21 | vet      | needed beak straightened
>                   |8-03 | vet      | broken rib
>                            |nnel   | N
>                            |nnel   | N
>      |     | 1998-08-28 | birthday | Gave him a new chew toy
>   |laws    | 1998-03-17 | birthday | Gave him a new flea collar
>| Whistler | 1998-12-09 | birthday | First birthday               |
>+----------+------------+----------+------------------------------+
>
>Anyone that can explain why this is happening?

Does the event.txt file have linefeeds for line endings, or something
else?

>
>Hälsningar / Regards                                 (\_/)  ))
>Danny Kohn                 Tel: +46 (0)708 140 300  =('.')=//  Miau!
>Systematik Consulting AB   ICQ: 1328817             ( ~~~ )/   Rrrrrui!
>http://www.systematik.se   HAM: SM0NBJ              `w---w´
>


-- 
Paul DuBois, paul@stripped
Thread
Why does example not work?Danny Kohn17 Sep
  • Re: Why does example not work?Paul DuBois17 Sep
    • SV: Why does example not work?Danny Kohn17 Sep
Re:Why does example not work?Heikki Tuuri17 Sep