读书人

MYSQL:施用\G参数改变输出结果集的显

发布时间: 2013-01-01 14:04:20 作者: rapoo

MYSQL:使用\G参数改变输出结果集的显示方式
在MYSQL命令行中使用\G参数,将输出按列显示。当需要看表中各字段的值时非常有用。
普通的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.

读书人网 >Mysql

热点推荐