According to the reference manual, the MySQL client has the command:
ego (\G) Send command to mysql server, display result vertically.
...
Each command has both a long and short form. The long form is not case sensitive; the short form is. The long form can be followed by an optional semicolon terminator, but the short form should not. [source]
I'm just playing around in the command line client and the \G form works:
select * from company \G
How would I use the long "ego" form if I wanted to? Does it work in the command line client? I just can't figure it out and Google isn't turning up anything.
Thanks!
Start MySQL client with --named-commands.
(none)>select 'hi'
-> ego
*************************** 1. row ***************************
hi: hi
1 row in set (0.00 sec)
ego
is available for command line only. By default queries are delimited using semicolons (;
). This applies to any API that connects to mysql
.
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