Results 1 to 3 of 3

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

  1. #1

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

    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?

  2. #2
    Will Honea NNTP User

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

    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

  3. #3
    Join Date
    Jan 2009
    Location
    Switzerland
    Posts
    1,529

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

    Is there anyway to enable a horizontal scrolling window?
    Yes, that's an option of the mysql client. Invoke as:

    Code:
    mysql --pager="less -S" <database>
    Use the left and right arrow keys to scroll.
    Technology is 'stuff that doesn't work yet.' -- Bran Ferren

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •