Shawn, Thanks for posting about the command window sizes. It's been something that I have frustratingly accepted in silence for a while now (especially having a 20 inch monitor at work).. Hooray!! I can finally get some horizontal real estate!!
..obviously the concept of two whole megabytes of buffer also gets me a little weak at the knees too ;) Regards, Lachlan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 6 August 2004 11:14 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Table query and column overlap 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) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
