欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

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

程序员文章站 2022-06-04 19:58:56
...
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
相关标签: mysql