MySQL Basics In Pictures
  1. Type:

    ALTER TABLE name ADD COLUMN party CHAR(25);

    then press ENTER.

    This command string will add a field, or column, to the table name. MySQL refers to table fields as columns.

    These commands read pretty much like a sentence in English:

    ALTER the TABLE name by ADDing a COLUMN called party. Then make party a column that contains a maximum of 25 characters.

    Now the table name is organized like this, with a new field called party:

    Column

    Datatype

    Properties

    id

    INT

    primary key, not null, auto increment

    first

    CHAR(25)

    last

    CHAR(25)

    party

    CHAR(25)