How can I combine the built-in commands (g and G) for executing MySQL statements with the terminating semicolon (;) to get output without any errors?

We know that the built-in commands (\G and \g) send the command to the MySQL server for execution, and with the help of the semicolon (;), MySQL determines the end of the statement. As we all know, their result set formats are also different. In order to combine them and get error-free results, we need to write two queries in a single statement, one using \G or \g and the other using a semicolon (;) at the end.

Example

Combining \G and a semicolon (;)−

mysql> Select * from student\G select * from ratelist;
*************************** 1. row ***************************
  Name: Gaurav
RollNo: 100
 Grade: B.tech
*************************** 2. row ***************************
  Name: Aarav
RollNo: 150
 Grade: M.SC
*************************** 3. row ***************************
  Name: Aryan
RollNo: 165
 Grade: M.tech

3 rows in set (0.00 sec)
+----+------+-------+
| Sr | Item | Price |
+----+------+-------+
| 1  | A    | 502   |
| 2  | B    | 630   |
| 3  | C    | 1005  |
| 4  | h    | 850   |
| 5  | T    | 250   |
+----+------+-------+
5 rows in set (0.00 sec)

In the above example, the MySQL statement First, \G is encountered after the first query and the result set based on it is displayed in vertical format. Then a semicolon (;) is encountered as a terminating symbol after the second query and the result set based on it is displayed in vertical format. Displayed in tabular format.

Example

Use \g with a semicolon (;)−

mysql> Select * from student\g select * from ratelist;
+--------+--------+--------+
| Name   | RollNo | Grade  |
+--------+--------+--------+
| Gaurav | 100    | B.tech |
| Aarav  | 150    | M.SC   |
| Aryan  | 165    | M.tech |
+--------+--------+--------+

3 rows in set (0.00 sec)
+----+------+-------+
| Sr | Item | Price |
+----+------+-------+
| 1  | A    | 502   |
| 2  | B    | 630   |
| 3  | C    | 1005  |
| 4  | h    | 850   |
| 5  | T    | 250   |
+----+------+-------+
5 rows in set (0.00 sec)

In the above example, the MySQL statement starts with the first \g is encountered after the query and the result set is thrown in tabular format based on it, then a semicolon (;) is encountered as the terminating symbol after the second query and the result set is thrown in tabular format based on it.

The above is the detailed content of How can I combine the built-in commands (g and G) for executing MySQL statements with the terminating semicolon (;) to get output without any errors?. For more information, please follow other related articles on the PHP Chinese website!