0

Having braved the task that is getting mySQL6.0 installed onto my machine, after listening to the preferences voiced by database users everywhere I was delighted when I finally got down to a bit of a play!!!
The problem I found almost immediately, was that a lot of the returned results do not fit into the command prompt window.Any lines which do not fit into what seems to be a predefined width return back on themselves and continue on the next line.
Needless to say, when you are attempting to view a grid everything becomes totally unintelligible.
Any suggestions please!!
Cheers

3
Contributors
3
Replies
4
Views
9 Years
Discussion Span
Last Post by peter_budo
0

Can you not use the \G switch?

select * from customers \G

This displays the field names vertically instead of across the top. At least in 5.* it does.

Otherwise you will have to play with your window size / font size.

0

Brilliant!! Thanks very much

SELECT * FROM user \G

worked perfect!!

I should probably be embarrassed!!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.