MySQL query uses \ g, column to row

• MySQL establish oracle Exercise table

Mysql At the end of the query, you can use \G、\g、; To specify the query format ,（ Only in command line mode , use navicat、dbeaver And other connection tools do not support ）

• Query usage \G, Result column to row

mysql> select * from emp limit 2\G
*************************** 1. row ***************************
   empno: 7369
   ename: SMITH
     job: CLERK
     mgr: 7902
hiredate: 1980-12-17
     sal: 800.00
    comm: NULL
  deptno: 20
*************************** 2. row ***************************
   empno: 7499
   ename: ALLEN
     job: SALESMAN
     mgr: 7698
hiredate: 1981-02-20
     sal: 1600.00
    comm: 300.00
  deptno: 30
2 rows in set (0.00 sec)

• Query usage \g And use ; The effect is the same

mysql> select * from emp limit 2\g
+-------+-------+----------+------+------------+---------+--------+--------+
| empno | ename | job      | mgr  | hiredate   | sal     | comm   | deptno |
+-------+-------+----------+------+------------+---------+--------+--------+
|  7369 | SMITH | CLERK    | 7902 | 1980-12-17 |  800.00 |   NULL |     20 |
|  7499 | ALLEN | SALESMAN | 7698 | 1981-02-20 | 1600.00 | 300.00 |     30 |
+-------+-------+----------+------+------------+---------+--------+--------+
2 rows in set (0.00 sec)

mysql> select * from emp limit 2;
+-------+-------+----------+------+------------+---------+--------+--------+
| empno | ename | job      | mgr  | hiredate   | sal     | comm   | deptno |
+-------+-------+----------+------+------------+---------+--------+--------+
|  7369 | SMITH | CLERK    | 7902 | 1980-12-17 |  800.00 |   NULL |     20 |
|  7499 | ALLEN | SALESMAN | 7698 | 1981-02-20 | 1600.00 | 300.00 |     30 |
+-------+-------+----------+------+------------+---------+--------+--------+
2 rows in set (0.00 sec)

mysql>