•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 423,579 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,436 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 524 | Replies: 3 | Solved
 |
•
•
Join Date: Jan 2008
Location: UK
Posts: 40
Reputation: 
Rep Power: 1
Solved Threads: 1
Light Poster
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
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
Ther are 10 types of people in the world. Those who do understand binary and those who don't!!
•
•
Join Date: Sep 2007
Location: North Bay Ontario
Posts: 176
Reputation:
Rep Power: 2
Solved Threads: 20
Junior Poster
Can you not use the \G switch?
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.
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.
Amer Neely - Web Mechanic
"Others make web sites. We make web sites work!"
"Others make web sites. We make web sites work!"
•
•
Join Date: Jan 2008
Location: UK
Posts: 40
Reputation:
Rep Power: 1
Solved Threads: 1
Light Poster
Brilliant!! Thanks very much
worked perfect!!
I should probably be embarrassed!!
SELECT * FROM user \G
worked perfect!!
I should probably be embarrassed!!
Ther are 10 types of people in the world. Those who do understand binary and those who don't!!
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,433
Reputation:
Rep Power: 11
Solved Threads: 295
No need, not many people would actualy know that
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- USB does not recognize. (Peripherals)
- getting ipconfig at command prompt (Windows NT / 2000 / XP / 2003)
- Borlands Turbo Debugger (Assembly)
- How to (Java)
- Viewing An IP Address in Command Prompt (Windows NT / 2000 / XP / 2003)
- Cannot View Certain Menus on Websites (Web Browsers)
- Cant view Site with Changed DNS (Windows NT / 2000 / XP / 2003)
Other Threads in the MySQL Forum
- Previous Thread: MySQL SUM Statemene
- Next Thread: Pivot table report
