Hi Danyu,
Well actually MySQL is showing u exactly what data exists in your table.
U may have insterted that values incorrectly. Just delete the records and
insert the values again.
Regards
Q
-----Original Message-----
From: Liu Danyu [mailto:dyliu@stripped]
Sent: 16 November 2000 04:51
To: mysql@stripped
Subject: how to adjust show format!
Importance: High
Dear all:
I want to see the correct result(exported by mysql)
on screen, but i met some problems.
when I use the command :
"select * from pets"
the screen result is
+------+-------------------+
| name | url |
+------+-------------------+
| | www.yahoo.com
|dog | www.cuhk.edu.hk
|| www.yahoo.com
+------+-------------------+
3 row in set <0.05 sec>
But the correct show format should be
+------+-------------------+
| name | url |
+------+-------------------+
| cat | www.yahoo.com |
| dog | www.cuhk.edu.hk |
| fish | www.yahoo.com |
+------+-------------------+
How I can get this correct screen result?
Thank you very much!
Danyu
