faqts : Computers : Databases : MySQL : Common Problems

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

3 of 5 people (60%) answered Yes
Recently 1 of 3 people (33%) answered Yes

Entry

Why are the database fields all written on top of one another when doing queries in my terminal?

Feb 29th, 2000 01:26
Nathan Wallace, Daniel Beckham, Sinisa Milivojevic


If you are doing this on the command line... it's because your terminal 
isn't wide enough to show all the data on one line... it's word
wrapping... try only selecting the columns you need to see instead of
all the columns at once... or use a larger terminal..

If you use mysql monitor program, each row comes in different line. 

You can use mysqlgui where you get your data in a spreadsheet form.