slm9tq
Last Updated: February 25, 2016
·
272
· mufid
Dc22fe194638f451dfabd21dcd5ea461

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

Say Thanks
Respond