AZinkey AZinkey - 10 months ago 50
MySQL Question

How to show records vertically in mysql command line?

First explaining what is on my mind {I'm not good at English}

On Alan Storm's blog I found a tricky thing about mysql I am not sure is he using command line or not. I have to ask from Alan that what it is as there comment section has closed so I am putting this query here.

mysql> select * from eav_entity_type\G

When I run this statement in my command line (Window dos based cmd) I just return normal select statement results.

Please let me know how could I get result as shown in that blog or if it is just part of a code beautifier.

Answer Source

I think you are using \g instead of \G. Unless you use \G you get default output pattern. Default is \g.

mysql> show databases\g
| Database           |
| information_schema |
| mysql              |
| test               |
3 rows in set (0.00 sec)

mysql> show databases\G
*************************** 1. row ***************************
Database: information_schema
*************************** 2. row ***************************
Database: mysql
*************************** 3. row ***************************
Database: test
3 rows in set (0.00 sec)