Member Avatar for lostandfound

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
  • 82 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by peter_budo
Member Avatar for trudge

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.

Member Avatar for lostandfound

Brilliant!! Thanks very much

SELECT * FROM user \G

worked perfect!!

I should probably be embarrassed!!

Member Avatar for peter_budo

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.