Nov. 5., 2007

unreadable output of MySQL console client

By Steffen Müller. Licensed under the Creative Commons License

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

--> Back to the list of articles

Tags: MySQL

License

Licensed under creative commonsThis article is licensed under the Creative Commons License CC BY-SA 3.0. You are free to share (copy, distribute and transmit) and to remix (to adapt) the work under the following conditions:

  • You must attribute the work by mentioning the name of the author (Steffen Müller) and setting a link back to the original article using its URL.
  • If you alter, transform, or build upon this work, you may distribute the resulting work only under the same or similar license to this one.

Comments

Leave a comment:

This page uses static caches. Make sure you reload the page in your browser after posting a comment.

(will not be published)

CAPTCHA image for SPAM prevention Click here for audio version of the word to enter.

If you can't read the captcha word, please click to load a new image.
(You need Javascript turned on. Otherwise press the submit button and wait until the page has reloaded.)