(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