Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

May 162010

Vertical (\G) output of query result in MySQL client


Sometimes, a query returning too much columns will make the query output not very readable in the MySQL client.

You can use the \G, instead of ; when executing the query, so the vertical output is shown.

mysql> show variables like '%thread%' \G
*************************** 1. row ***************************
Variable_name: max_delayed_threads
        Value: 20
*************************** 2. row ***************************
Variable_name: max_insert_delayed_threads
        Value: 20
*************************** 3. row ***************************
Variable_name: myisam_repair_threads
        Value: 1
*************************** 4. row ***************************
Variable_name: pseudo_thread_id
        Value: 169
*************************** 5. row ***************************
Variable_name: thread_cache_size
        Value: 12
*************************** 6. row ***************************
Variable_name: thread_handling
        Value: one-thread-per-connection
*************************** 7. row ***************************
Variable_name: thread_stack
        Value: 262144
7 rows in set (0.00 sec)

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>