日期:2014-05-16 浏览次数:20872 次
        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. |
        +------+------------+----------+------------+-----------------------------------
        -----------------------------+        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.