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.