mysql> ALTER TABLE mytable ADD COLUMN model_type varchar(10) NOT NULL;
mysql>ALTER TABLE mytable MODIFY COLUMN name varchar(20) NOT NULL;
mysql>ALTER TABLE mytable CHANGE COLUMN modelnumber model_num varchar(10) NOT NULL;
mysql>ALTER TABLE mytable DROP COLUMN series;