MySQL Forums
Forum List  »  MySQL Query Browser

Vertical Format in the Query Browser? (\G)
Posted by: Rushi Vishavadia
Date: October 25, 2008 09:04AM

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.

Options: ReplyQuote


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.