You need to change the buffer size of your, for lack of a better term,
"DOS prompt window".
RIGHT-click on the title bar of your window and click on properties.
On the properties page for my platform (win2k) I have a Layout tab. On
that tab are two "size" settings, Screen Buffer Size and Window Size. You
need to change your Screen Buffer Size to be something with a width
greater than the output of most of the queries you run. In my case I run
1024 (width) x 2048 (height) which allocates a "whopping" 2MB buffer
(oh--my goodness!!! not two whole megabytes!! 8-D ) You get 1024
horizontal columns so you won't see that wrapping nearly as often. You
also get 2048 lines of output buffer as well. I can run most queries and
not need to worry about them scrolling out of the top of my buffer.
Of course, you can always change those numbers to fit _your_
circumstances.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Remember14a@stripped wrote on 08/05/2004 11:15:35 PM:
> Dear Friends,
> I am using mysql 4.0.17-nt
> I have pasted structure of table below, while managing through command
prompt
> using sql without GUI.
>
> Once I use without GUI, via command prompt
>
> select * from quiz
> to see contents of full table in each column
> I get overlap of columns as pasted below, how do I fix it. Any guidance,
> please.
>
>
>
-----------------------------------------------------------------------------
>
>
> sql> select * from quiz;
>
---+----+---------------------------------------------------------+-----------
> ----+------------+---------+-----------------+-----------+
> id | q | question | opt1
> | opt2 | opt3 | answer | activated |
>
---+----+---------------------------------------------------------+-----------
> ----+------------+---------+-----------------+-----------+
> 1 | 1 | Which drug is the treatment of choice in hypertension? | Loop
dirur
> ics | omperazole | heparin | Loop diruretics | 1 |
> 2 | q2 | |
> | | | | 1 |
> 3 | | |
> | | | | 1 |
>
---+----+---------------------------------------------------------+-----------
> ----+------------+---------+-----------------+-----------+
> rows in set (0.00 sec)
