MYSQL：使用/G参数改变输出结果集的显示方式_MySQL

bitsCN.com

MYSQL：使用/G参数改变输出结果集的显示方式

 

   在MYSQL命令行中使用/G参数，将输出按列显示。当需要看表中各字段的值时非常有用。

        普通的SQL命令输出如下：    

[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选项的输出：

[sql] 

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参数后，结果集默认以列的方式显示：

 

[sql] 

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.  

 

bitsCN.com