List:General Discussion« Previous MessageNext Message »
From:QDelpeche Date:November 16 2000 4:37am
Subject:RE: how to adjust show format!
View as plain text  
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



Thread
how to adjust show format!Liu Danyu16 Nov
  • Re: how to adjust show format!Rolf Hopkins16 Nov
  • Re: how to adjust show format!Rolf Hopkins16 Nov
RE: how to adjust show format!QDelpeche16 Nov