ALTER TABLE

• http://dev.mysql.com/doc/refman/4.1/en/alter-table.html

ALTER TABLE tablename
(
  ADD|DROP  COLUMN  datatype  [NULL|NOT NULL]  [CONSTRAINTS],
  ADD|DROP  COLUMN  datatype  [NULL|NOT NULL]  [CONSTRAINTS],
  ...
);

• alter table parcels add primary key (`id`);

• alter table parcels add key (`area`);
• alter table parcels add index (`owner`);

• alter table mytable CONVERT TO CHARACTER SET latin1;
• alter table mytable CONVERT TO CHARACTER SET latin1 [COLLATE collation_name];