How can we run a MySQL statement without termination semicolon?

With the help of \G or \g option just at the end of the MySQL statement, we can run it without the semicolon. Consider the example below −

mysql> Select * from Stock_item\G *************************** 1. row *************************** item_name: Calculator     Value: 15  Quantity: 89 *************************** 2. row *************************** item_name: Notebooks     Value: 63  Quantity: 40 *************************** 3. row *************************** item_name: Pencil     Value: 15  Quantity: 40 *************************** 4. row *************************** item_name: Pens   Value : 65 Quantity: 32 *************************** 5. row *************************** item_name: Shirts     Value: 13  Quantity: 29 *************************** 6. row *************************** item_name: Shoes     Value: 15  Quantity: 29 *************************** 7. row *************************** item_name: Trousers     Value: 15  Quantity: 29 7 rows in set (0.00 sec)

The above query with \G (omitting semicolon) returns the result set in a vertical format.

mysql> Select * from Stock_item\g +------------+-------+----------+ | item_name  | Value | Quantity | +------------+-------+----------+ | Calculator |    15 |       89 | | Notebooks  |    63 |       40 | | Pencil     |    15 |       40 | | Pens       |    65 |       32 | | Shirts     |    13 |       29 | | Shoes      |    15 |       29 | | Trousers   |    15 |       29 | +------------+-------+----------+ 7 rows in set (0.00 sec)

The above query with \g (omitting semicolon) returns the result set in a tabular format.