I need more columns

Discussion in 'MySQL' started by stupidfly, Dec 8, 2006.

0
  1. #1
    I want to add more columns to a table in MySQL. Is this possible? Do I have to make a whole new table?
     
    stupidfly, Dec 8, 2006 IP
  2. frankcow

    frankcow Well-Known Member

    Messages:
    4,859
    Likes Received:
    265
    Best Answers:
    0
    Trophy Points:
    180
    #2
    it's simple to do this, just edit the table!

    do you have phpmyadmin?
     
    frankcow, Dec 8, 2006 IP
  3. stupidfly

    stupidfly Peon

    Messages:
    129
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Wow, that is pretty pathetic that I couldn't figure that out. Haha. Thanks for the help.
     
    stupidfly, Dec 8, 2006 IP
  4. frankcow

    frankcow Well-Known Member

    Messages:
    4,859
    Likes Received:
    265
    Best Answers:
    0
    Trophy Points:
    180
    #4
    it's not pathetic at all, don't ever feel dumb for asking a question!
     
    frankcow, Dec 11, 2006 IP
  5. Scolls

    Scolls Guest

    Messages:
    70
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Just out of interest, you can also just run an sql to do it:

    alter table table_name add column column_name column_type
     
    Scolls, Dec 15, 2006 IP