Print MySQL Table Fields

Discussion in 'MySQL' started by obenix, Sep 6, 2005.

  1. #1
    How do I print out the fields and it's related attributes from tables in MySQL?
    I use MySQL Control Center but I see no print function...:(
     
    obenix, Sep 6, 2005 IP
  2. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #2
    show create table <table_name>;
     
    noppid, Sep 6, 2005 IP
  3. T0PS3O

    T0PS3O Feel Good PLC

    Messages:
    13,219
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Print as in on Paper? Or print as in the PHP function print etc?
     
    T0PS3O, Sep 6, 2005 IP
  4. obenix

    obenix Eats an apple a day......

    Messages:
    2,236
    Likes Received:
    180
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Print as in print on a piece of paper..:p
     
    obenix, Sep 6, 2005 IP
  5. T0PS3O

    T0PS3O Feel Good PLC

    Messages:
    13,219
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I forgot how paper even looks like so I don't have a clue :)

    Welcome to the digital era!
     
    T0PS3O, Sep 6, 2005 IP
  6. obenix

    obenix Eats an apple a day......

    Messages:
    2,236
    Likes Received:
    180
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Yeah... My eyesight is not getting any better from reading from the screen..:D
    I dislike having to toggle my screen from PHP programming and MySQL...
    I thought I might as well print out a copy and stick it on the wall...
     
    obenix, Sep 6, 2005 IP
  7. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #7
    Here's a novel idea.

    Dump the table structure.
    Copy and paste to your favorite editor.
    Click the "print" icon.
     
    noppid, Sep 6, 2005 IP
  8. Liminal

    Liminal Peon

    Messages:
    1,279
    Likes Received:
    63
    Best Answers:
    0
    Trophy Points:
    0
    #8
    1) Connect to your server
    2) Issue command: describe <your-table-name>;

    Alternatively, use phpMyAdmin if you have access to it. I don't think their MySQL Control Center can do it
     
    Liminal, Sep 8, 2005 IP