The long form of the MySQL ego client command, how to use it?

According to the reference guide, the MySQL client has the command:

ego (\ G) Send the command to mysql server, display the result vertically.

...

Each team has a long and short form. The long form is not case sensitive; short form. The long form may be followed by an optional terminator with a comma, but the short form should not. [a source]

I just play in the command line client and the \ G form works:

select * from company \G 

How can I use the long ego if I want? Does it work in a command line client? I just can't figure it out, and Google is not doing anything.

Thanks!

+6
mysql
source share
2 answers

Start the MySQL client using named commands.

 (none)>select 'hi' -> ego *************************** 1. row *************************** hi: hi 1 row in set (0.00 sec) 
+6
source share

ego is available only on the command line. By default, requests are separated by a comma ( ; ). This applies to any API that connects to mysql .

+1
source share

All Articles