Home  >  Article  >  Database  >  How to display MySQL query results vertically?

How to display MySQL query results vertically?

PHPz
PHPzforward
2023-09-07 20:45:03946browse

How to display MySQL query results vertically?

By using the ego, \G option at the end of the statement, we can get the result set in vertical format. Consider the following example

mysql> Select * from Student where name = 'Aarav'\G
*************************** 1. row ***************************
  Name: Aarav
RollNo: 150
 Grade: M.SC
1 row in set (0.00 sec)

The above is the detailed content of How to display MySQL query results vertically?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete