Anyway to enable horizontal scrolling in terminal window? (SQL tables)

[wombatvvv]

I find that when looking at various SQL tables in the the terminal window, they become un-readable because the table data warps around. Is there anyway to enable a horizontal scrolling window?

[Will Honea]

wombatvvv wrote:

>
> I find that when looking at various SQL tables in the the terminal
> window, they become un-readable because the table data warps around. Is
> there anyway to enable a horizontal scrolling window?

IBM implments horizonal scrolling in their Java-based Command Center. Last
place I worked on SQL resorted to multiple displays - kinda like swatting
flies with a sledge hamer ;-)

You can get a degree of scrolling (actually panning) by some tricks with the
display size definition. Just define the display as being wider than the
monitor. Not a very satisfactory arrangement as it usually results in poor
text quality.

The only good way is to write your own app to display the output. It's not
that hard to do. If you use Libre Office and can get the Base functions
working, that's essentially what you get. Just imagine a spread sheet with
100 columns ;-)

--
Will Honea

[vodoo]

Is there anyway to enable a horizontal scrolling window?

Yes, that's an option of the mysql client. Invoke as:

mysql --pager="less -S" <database>

Use the left and right arrow keys to scroll.