alter table add column
ALTER TABLE table ADD COLUMN column VARCHAR (255) NOT NULL AFTER column;
Add column in table
ALTER TABLE table_name ADD column_name column_definition;
Add a new column into table
ALTER TABLE table ADD [COLUMN] column_name;
Source: www.mysqltutorial.org
how to add column sql
ALTER TABLE Customers ADD Email varchar(255);