Menu
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 if he's using the command line or not. The comment section has closed over there, so I'm putting this query here instead.
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.
293
To get this output format, start MySQL Shell with the --result-format=vertical command line option (or its alias --vertical ), or set the MySQL Shell configuration option resultFormat to vertical .
You can get MySQL to display results vertically: Some query results are much more readable when displayed vertically, instead of in the usual horizontal table format. Queries can be displayed vertically by terminating the query with \G instead of a semicolon.
You can output query results vertically instead of a table format. Just type \G instead of a ; when you end you queries in mysql prompt.
The first command you will need to use is the SELECT FROM MySQL statement that has the following syntax: SELECT * FROM table_name; This is a basic MySQL query which will tell the script to select all the records from the table_name table.
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) If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
