mysql结果垂直显示-\g和\G的用法
1.mysql中的\G和\g;
2.值得注意的是直接在mysql工具里面执行会被转义成: select * from member limit 3G;导致直接报错。
3.直接在命令行执行是没有任何问题的如图:
(1).\g等价于;号,例如下面两条sql语句的输出结果是一样的:
select * from member limit 3 \g; select * from member limit 3;
输出结果:
+----+-------+ | id | name | +----+-------+ | 1 | zhang | | 1 | zhang | | 1 | zhang | +----+-------+ 3 rows in set (0.00 sec)
(2).\G是为了让输出结果纵向显示
select * from member limit 3\G;
输出结果:
*************************** 1. row *************************** id: 1 name: zhang *************************** 2. row *************************** id: 1 name: zhang *************************** 3. row *************************** id: 1 name: zhang