目录

[TOC]

法1 末尾加\G，即可使行列互换（转置）

如select host,user from mysql.user;

    -> ;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | root             |
| localhost | debian-sys-maint |
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
6 rows in set (0.00 sec)

返回的结果是这样

末尾加\G后可以省略原末尾的;(不省略也可)
正确写法：

select host,user from mysql.user\G
错误写法：
select host,user from mysql.user;\G
select host,user from mysql.user\G;
最后输出是这样的:

*************************** 1. row ***************************
host: %
user: root
*************************** 2. row ***************************
host: localhost
user: debian-sys-maint
*************************** 3. row ***************************
host: localhost
user: mysql.infoschema
*************************** 4. row ***************************
host: localhost
user: mysql.session
*************************** 5. row ***************************
host: localhost
user: mysql.sys
*************************** 6. row ***************************
host: localhost
user: root
6 rows in set (0.00 sec)

法2 pager less -SFX

进入mysql后，输入pager less -SFX,然后再正常输入查询语句即可。

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> pager less -SFX
PAGER set to 'less -SFX'
mysql> select host,user from mysql.user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | root             |
| localhost | debian-sys-maint |
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
6 rows in set (0.00 sec)

表超出显示范围的话，通过上下左右键来移动，退出时轻点Q即可。