display too many columns has a problem

[fxtong]

lines will auto wrap because item2 NOT allow to scroll horizontally and it seems not tidy at all, how to deal with it?

[amjith]

You can add a \G a the end of the query to switch the display mode to vertical.

SELECT * FROM tablename \G

[fxtong]

Hmm, this way display less data on screen, is there any other solution?

[amjith]

Maybe you can show us a screenshot so we can help you better.

[fxtong]

I make a sample and you can see in this situation we are difficult to find out the column we want, if we can scroll horizontally, it will be clear and aligned...

[amjith]

You can specifically force the pager to the following value which will allow you to do horizontal scroll.

 mycli> \P less -XSRF

I'm assuming you're on linux.

If you're on Windows this might require installing a pager like less.exe and using that. I'm not too familiar with Windows.

[fxtong]

thanks a lot! It really help me