stmllr.net

Unreadable output of MySQL console client

by on stmllr.net

tl;dr Terminate your MySQL query with \G instead of ; or \g to get some more readable output

Are you a fan of using MySQL console client? Have you ever experienced the unreadable chaos of table data, when doing queries on tables with lots of columns? The usability of this tool often ends with the first linebreak.

The solution to get some more readable output is so easy: Terminate your query with \G instead of ; or \g

Tags