Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

Archive: I need more columns

Bottom of Page

1 to 2 of 2

  1.  
    • CommentAuthorgilray
    • CommentTimeDec 13th 2006
     
    I want to add more columns to a table in MySQL. Is this possible? Do I have to make a whole new table?
    • CommentAuthorjustnajm
    • CommentTimeDec 14th 2006
     
    Not at all my dear friend. Here is the method you can use


    ALTER TABLE table_name ADD COLUMN column_name column_attributes


    For example:

    ALTER TABLE cars ADD COLUMN color text not null;


    When you have a question, just post the topic, we are here to help.

1 to 2 of 2

  1.