MYSQL：使用\G參數改變輸出結果集的顯示方式
在MYSQL命令行中使用\G參數，將輸出按列顯示。當需要看表中各字段的值時非常有用。
普通的SQL命令輸出如下： www.2cto.com
[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”的錯誤。
www.2cto.com
這樣的顯示效果與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.
