当前位置:Gxlcms > mysql > MYSQL:使用/G参数改变输出结果集的显示方式_MySQL

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

时间:2021-07-01 10:21:17 帮助过:4人阅读

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

人气教程排行