Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Unreadable output to monitor

    Hey guys,

    I'm taking a MySQL class. For a project, I constructed a table with quite a few columns. Outputting the entire table to the screen produces a nearly-unreadable display; the rows basically "wrap" themselves to fit the screen, thus becoming a garbled mess. Is there a way to correct this with a MySQL command, or is this a fault of the server hosting MySQL?

    Thanks much!

  2. #2
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137

    Re: Unreadable output to monitor

    When concluding your query, use \G instead of ;
    For instance:
    Code:
    SELECT * FROM table1\G
    This is formated with each field on a new line instead of columnar.

  3. #3
    Join Date
    Mar 2004
    Posts
    2
    Thanks!! Very helpful!!

Posting Permissions

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