Thread: viewing columns

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    179
    Rep Power
    15
    When I SELECT * from MYTABLE the table isn't very readable because some of the info in the table causes the rows to wrap around to the next line.

    Is there a way to make the table more readable?
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    27
    Rep Power
    0
    you could try to split your table by means of a query

    example:
    table has rows:
    UID int, name char(50), counrty char(50)

    you can select the different columns as like this:

    select UID,name from table_name
    or
    select name,country from table_name
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    179
    Rep Power
    15
    Thanks,

    That's a great solution. Somebody also tipped me off to:

    SELECT * FROM mytable G <ENTER>

    However, now I'm wondering how to look at each row before it scrolls up the screen.

    Anyway, thanks everybody.

Similar Threads

  1. LOAD DATA into table, ignoring some columns?
    By baddy in forum MySQL Help
    Replies: 1
    Last Post: September 18th, 2003, 11:35 AM
  2. Can't view MySQL table columns in Win installation
    By chaos theory in forum MySQL Help
    Replies: 0
    Last Post: August 15th, 2002, 07:00 PM
  3. Replies: 5
    Last Post: July 10th, 2002, 04:25 PM
  4. Querying multiple columns
    By maxr in forum MySQL Help
    Replies: 2
    Last Post: April 10th, 2002, 02:17 PM
  5. show columns command
    By jiml in forum MySQL Help
    Replies: 0
    Last Post: June 6th, 2000, 11:45 PM

IMN logo majestic logo threadwatch logo seochat tools logo