日期:2014-05-16 浏览次数:20768 次
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. | +------+------------+----------+------------+----------------------------------- -----------------------------+
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.