Results 1 to 2 of 2

Thread: Show columns help

  1. #1
    Join Date
    Sep 2009
    Location
    New Jersey
    Posts
    3

    Show columns help

    I am using mysql via terminal window... I believe mysql is running on fedora.. The database i am using has over 400 fields.. I am running SHOW columns FROM mydatabase; to produce a list of all the fields_names, types and length. This does works. However, I am unable to read the first several fields as my terminal is limited. How can i print out the field name, type, and lenght of a specific field without listing all the fields in columns. Also, does my sql have a | more feature?

  2. #2
    Join Date
    Feb 2011
    Posts
    6

    Show columns

    You can do:

    Show tables from tablename\G

    This would get you the results with the values displayed vertically

    Bert

Posting Permissions

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