LMSouq
database Open

How to best display in Terminal a MySQL SELECT returning too many fields?

CH
Chris Jacob
1 month ago
3 views
Problem Description
I'm using [PuTTY][1] to run: mysql> SELECT * FROM sometable; `sometable` has many fields and this results in many columns trying to be displayed in the terminal. The fields wrap onto the next line so it is very hard to line up column titles with field values. **What solutions are there for viewing such data in terminal?** I don't have nor want access to phpMyAdmin - or any other GUI interfaces. I'm looking for command-line solutions such as this one: [Save MySQL Query results into text or CVS file][2] [1]: https://www.putty.org/ [2]: http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base