ALTER TABLE Table_name ADD Email varchar(255);
ALTER TABLE Table_name ADD name_column INT(255);
ALTER TABLE table_name ADD [COLUMN] column_name column_definition [FIRST|AFTER existing_column];
ALTER TABLE `TABLE_NAME` ADD `COLUMN_NAME` VARCHAR(50) NULL AFTER `COLUMN_NAME_AFTER`;
ALTER TABLE vendors ADD COLUMN phone VARCHAR(15) AFTER name;
ALTER TABLE table ADD [COLUMN] column_name column_definition [FIRST|AFTER existing_column];