Best Way to Show Many Field in MySQL

Basically, if you do

SELECT * from persons;

you will get table showing your entire data. Unfortunately, this will become unreadable if you have so much field.

If you have a lot of field in MySQL Table, you can show it as linear row (instead showing it as full table). You can add \G to the query:

SELECT * from persons\G;

source