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
lostandfound
10
Junior Poster in Training
Recommended Answers
Jump to PostCan you not use the \G switch?
select * from customers \GThis 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.
All 3 Replies
trudge
8
Junior Poster
Can you not use the \G switch?
select * from customers \GThis 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.
lostandfound
10
Junior Poster in Training
Brilliant!! Thanks very much
SELECT * FROM user \Gworked perfect!!
I should probably be embarrassed!!
peter_budo
2,532
Code tags enforcer
Team Colleague
Featured Poster
No need, not many people would actualy know that
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.