Home >Database >Mysql Tutorial >MYSQL：使用/G参数改变输出结果集的显示方式_MySQL
MYSQL：使用/G参数改变输出结果集的显示方式_MySQL
- WBOYOriginal
- 2016-06-01 13:37:311553browse
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