日期:2014-05-16  浏览次数:20756 次

MYSQL:使用\G参数改变输出结果集的显示方式
        在MYSQL命令行中使用\G参数,将输出按列显示。当需要看表中各字段的值时非常有用。
        普通的SQL命令输出如下:
        mysql> select * from t_goods;
        +------+------------+----------+------------+-----------------------------------
        -----------------------------+
        | id   | goods_name | quantity | add_date   | description
                                     |
        +------+------------+----------+------------+-----------------------------------
        -----------------------------+
        |    1 | MYSQL5      |       50 | 2012-12-12 | A book that has been read but is i
        n good condition. See the seller’s listing for full details and descr iption of
        any imperfections. |
        +------+------------+----------+------------+-----------------------------------
        -----------------------------+

        下面是使用\G选项的输出:
        mysql> select * from t_goods \G
        *************************** 1. row ***************************
                 id: 1
         goods_name: MYSQL5
           quantity: 50
           add_date: 2012-12-12
        description: A book that has been read but is in good condition. See t
        he seller’s listing for full details and description of any imperfections.

        注意:\G为大写字母,不可使用小写;使用\G参数后,SQL语句后可以不加分隔符,如果加分隔符,则会报“error:no query specified”的错误。

        这样的显示效果与MYSQL命令的-E参数是一样的。使用-E参数后,结果集默认以列的方式显示:

        C:\Users\qxl>mysql -uroot -E
        Welcome to the MySQL monitor.  Commands end with ; or \g.
        Your MySQL connection id is 13
        Server version: 5.1.28-rc-community MySQL Community Server (GPL)
        
        Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
        
        mysql> use test;
        Database changed
        mysql> select * from t_goods;
        *************************** 1. row ***************************
                 id: 1
         goods_name: MYSQL5
           quantity: 50
           add_date: 2012-12-12
        description: A book that has been read but is in good condition. See t
        he seller’s listing for full details and description of any imperfections.