MySQL: how to be abble to see well aranged tables?

xpucto · 03-12-2009, 05:10 AM

Hi!
when doing for example

Code:

select * from myTable;

it may happen that the result in the shell window shows fields that are not properly arranged when some fields too big are. In those cases it is just impossible to read anything.
How may I get readable results even when fields are very long?

Thanks

T74marcell · 03-12-2009, 06:09 AM

You can specifically list the fields that you want to see.

Quote:

SELECT name, address, phone FROM TABLE adressbook;

Assuming that 'addressbook' has these fields (among others), only these ones will be listed. You can also limit the number of results:

Quote:

SELECT name, address, phone FROM TABLE addressbook WHERE id>'999' LIMIT 10;

Get yourself some good SQL documentation or tutorial.

Arch Linux

xpucto · 03-13-2009, 03:32 AM

Thank you for your answer. I already know the answers you gave though and it doesn´t solve my problem.
1) I need to see all the fields
2) the number of rows are not the problem but their length which does not pass to the width of my screen.

xpucto · 03-13-2009, 03:55 AM

ok, I´ve got it:

Code:

select * from myTable \G