iamnearlythere

Properly Display MySQL Result in Console

If your query results in a result set with many columns, you might end up with totally unreadable jibberish since the console defaults to print the columns horizontally. To display the data vertically instead, with support for really many columns, end the query with \G:

select * from users \G

... instead of

select * from users;