Vertical Format in the Query Browser? (\G)
I wanted to know is it possible to have the Query browser output data in the vertical format? i.e. the \G option
Example:
mysql> explain select * from Survey\G;
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: Survey
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
rows: 559566
Extra:
1 row in set (0.08 sec)
Rather than
mysql> explain select * from Survey;
+----+-------------+--------+------+---------------+------+---------+------+--------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------+------+---------------+------+---------+------+--------+-------+
| 1 | SIMPLE | Survey | ALL | NULL | NULL | NULL | NULL | 559566 | |
+----+-------------+--------+------+---------------+------+---------+------+--------+-------+
1 row in set (0.00 sec)
The \G option is much easier to read in many cases.
Subject
Written By
Posted
Vertical Format in the Query Browser? (\G)
October 25, 2008 09:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.