# Tips
__*\G*__
__*pager less -S*__
+ Use **`\G`** instead of semicolons **`;`** to display rows in results vertically
+ Use asterisks with caution, it can be a waste of resources and have unpredictable results due to definition changes
+ Use the **`DESC {query_statement}`** or **`EXPLAIN {query_statement}`** to get the physical execution plan of SQL statements
+ When you use a `MySQL client` program to connect to `TiDB`, you can set up a session using the **`pager less -S`** command to read the full screen output in a moving window manner  
  + Use **`q`** to exit the window
  + Use **`\n`** to go back to standard output

------------------------------------------------------------
```
tidb> select name, mass from planets;
+---------+-------+
| name    | mass  |
+---------+-------+
| Mercury |  0.33 |
| Venus   |  4.87 |
| Earth   |  5.97 |
| Mars    | 0.642 |
| Jupiter |  1898 |
| Saturn  |   568 |
| Uranus  |  86.8 |
| Neptune |   102 |
| Pluto   | 0.013 |
+---------+-------+
9 rows in set (0.00 sec)

tidb> select name, mass from planets\G
*************************** 1. row ***************************
name: Mercury
mass: 0.33
*************************** 2. row ***************************
name: Venus
mass: 4.87
*************************** 3. row ***************************
name: Earth
mass: 5.97
*************************** 4. row ***************************
name: Mars
mass: 0.642
*************************** 5. row ***************************
name: Jupiter
mass: 1898
*************************** 6. row ***************************
name: Saturn
mass: 568
*************************** 7. row ***************************
name: Uranus
mass: 86.8
*************************** 8. row ***************************
name: Neptune
mass: 102
*************************** 9. row ***************************
name: Pluto
mass: 0.013
9 rows in set (0.00 sec)
```