转自:http://blog.csdn.net/warmspace2008/article/details/8334010
在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.