ALTER TABLE table_name<br /> ADD [COLUMN] column_name column_definition [FIRST|AFTER existing_column];

ALTER TABLE vendors ADD COLUMN phone VARCHAR(15) AFTER name;

ALTER TABLE Table_name<br /> ADD Email varchar(255);

ALTER TABLE `TABLE_NAME`<br /> ADD `COLUMN_NAME` VARCHAR(50) NULL<br /> AFTER `COLUMN_NAME_AFTER`;

ALTER TABLE Table_name ADD name_column INT(255);

— ALTER TABLE tbl_name ADD COLUMN column_name column_definition<br /> — [FIRST|AFTER existing_column];<br /> ALTER TABLE office ADD COLUMN phone VARCHAR(200) DEFAULT ‘000’ AFTER name;<br /> ALTER TABLE office ADD COLUMN flag INT(1) FIRST;<br /> ALTER TABLE office ADD COLUMN last_col INT(2); — Last column is default position<br /> — ↓ Test it (Fiddle)

ALTER TABLE contacts<br /> ADD last_name varchar(40) NOT NULL<br /> AFTER contact_id;

ALTER TABLE table<br /> ADD [COLUMN] column_name_1 column_1_definition [FIRST|AFTER existing_column],<br /> ADD [COLUMN] column_name_2 column_2_definition [FIRST|AFTER existing_column],<br /> …<br /> ;

ALTER TABLE table ADD [COLUMN] column_name column_definition [FIRST|AFTER existing_column];

ALTER TABLE table<br /> ADD [COLUMN] column_name column_definition<br /> [FIRST|AFTER existing_column];