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 [EMAIL PROTECTED] 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)
