I recently installed MySQL on a computer running Windows 2000 and
have been working through the tutorial session in the manual. All
went well until I created the second (event) table. While I believe
that all the data in the table is correct, any query which returns
the remark column results in a distorted display. I've been working
from a command prompt window. Pasted below is the output of one
session.
Is this a bug in the windows version of MySQL, or am I screwing up?
Also, is there a free GUI available for the MySQL client?
Jeff Allen
------------------------------------------------------------------
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.49-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use menagerie;
Database changed
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)
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
| Bowser | 1991-10-12 | kennel | NULL |
| Fang | 1991-10-12 | kennel | NULL |
| | 1998-08-28 | birthday | Gave him a new chew toy
|laws | 1998-03-13 | birthday | Gave him a new flea collar
| Whistler | 1998-12-09 | birthday | First Birthday |
+----------+------------+----------+------------------------------+
10 rows in set (0.00 sec)
mysql> select name,date,type from event;
+----------+------------+----------+
| name | date | type |
+----------+------------+----------+
| Fluffy | 1995-05-15 | litter |
| Buffy | 1993-06-23 | litter |
| Buffy | 1994-06-19 | litter |
| Chirpy | 1999-03-21 | vet |
| Slim | 1997-08-03 | vet |
| Bowser | 1991-10-12 | kennel |
| Fang | 1991-10-12 | kennel |
| Fang | 1998-08-28 | birthday |
| Claws | 1998-03-13 | birthday |
| Whistler | 1998-12-09 | birthday |
+----------+------------+----------+
10 rows in set (0.00 sec)
mysql> select remark from event;
+------------------------------+
| remark |
+------------------------------+
|4 kittens, 3 female, 1 male
|5 puppies, 2 female, 3 male
|s, 3 female
|ded beak straightened
|
| NULL |
| NULL |
| him a new chew toy
|ave him a new flea collar
| First Birthday |
+------------------------------+
10 rows in set (0.00 sec)
mysql>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
