469,111 Members | 1,961 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

Jumbled output

Hello

The problem I am experiencing is the output from the select statement
below. The table breaks up on the left side and loses information.

Yet, when I run the select command from a batch file (second group), it
looks as if everything is in order - tab separated fields.

Another problem (I think) is the null (\N) fields became 'N' under remarks
in the 6th and 7th rows.

(This example is from the MySQL manual tutorial.)

Can anyone point out the error if there is one? Many thanks for any
help offered.

Chris

mysql> select * from event;
+----------+------------+----------+------------------------------+
| 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
|98-12-09 | birthday | First birthday
+----------+------------+----------+------------------------------+
10 rows in set (0.00 sec)

C:\mysql>mysql < batch_file.txt
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
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

mysql> describe event;
+--------+--------------+------+-----+---------+-------+
| 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 | |
+--------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
Jul 19 '05 #1
2 1902
ch*****@pulsenet.com (Chris Charley) wrote in message news:<4f*************************@posting.google.c om>...
Hello


I think I should provide the following info.

I am using version 4.0.16. of MySQL installed on my stand alone
computer. For my internet connection, I use dial-up access.
Apache 2.0.48 is installed on my PC.

My operating system is Windows XP with Service pack 1 installed.

Chris
Jul 19 '05 #2
ch*****@pulsenet.com (Chris Charley) wrote in message news:<4f*************************@posting.google.c om>...
Hello


I think I should provide the following info.

I am using version 4.0.16. of MySQL installed on my stand alone
computer. For my internet connection, I use dial-up access.
Apache 2.0.48 is installed on my PC.

My operating system is Windows XP with Service pack 1 installed.

Chris
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Mark Wilson CPU | last post: by
reply views Thread by Chris Charley | last post: by
3 posts views Thread by edgekaos | last post: by
reply views Thread by newbie | last post: by
3 posts views Thread by =?Utf-8?B?Rm9nZ3k=?= | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.