How can I display MySQL query result vertically?

With the use of ego, \G option at end of a 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)

Abhinaya

Published on 22-Feb-2018 05:45:19

• Related Questions & Answers
• How do I split a numerical query result in MySQL?
• How can I make my layout scroll vertically?
• How to display records vertically in MySQL command line?
• How can I stop running a MySQL query?
• How can I stop a running MySQL query?
• How can I make my layout scroll vertically in Android?
• How can you order the result obtained by select query in MySQL?
• How can I enable MySQL slow query log without restarting MySQL?
• How can I achieve similar result like using a loop in MySQL WHERE clause to display only alternate ID records?
• How can I position JButtons vertically one after another in Java Swing?
• Display substrings of different length with a single MySQL query and combine the result
• Can we remove _id from MongoDB query result?
• How Can MySQL operator precedence affect result set?
• How to store Query Result in a variable using MySQL?
• How can I add one day to DATETIME field in MySQL query?