Simple syntax question

Hi

I don't remember how to get the diplayed result broken
in multiple lines.

The command: mysql> SHOW INDEX FROM recentchanges;
gives one very large line that wrapped over the screen.

I think that using another character instead of ; for
termination would give one line per field.

Thanks

Hompf wrote:
> Hi
>
> I don't remember how to get the diplayed result broken
> in multiple lines.
>
> The command: mysql> SHOW INDEX FROM recentchanges;
> gives one very large line that wrapped over the screen.
>
> I think that using another character instead of ; for
> termination would give one line per field.
>
> Thanks

Just type
mysql> help
and you get several lines, among which, this one:
....
ego (\G) Send command to mysql server, display result vertically.
....

ciao
gmax


--
_ _ _ _
(_|| | |(_|>< The Data Charmer
_|
http://datacharmer.blogspot.com/

Giuseppe Maxia wrote:
> Hompf wrote:
>> Hi
>>
>> I don't remember how to get the diplayed result broken
>> in multiple lines.
>>
>> The command: mysql> SHOW INDEX FROM recentchanges;
>> gives one very large line that wrapped over the screen.
>>
>> I think that using another character instead of ; for
>> termination would give one line per field.
>>
>> Thanks
>
> Just type
> mysql> help
> and you get several lines, among which, this one:
> ...
> ego (\G) Send command to mysql server, display result vertically.
> ...

Thanks
I was googling instead and loosing much time.