To insert new column in a table we use ALTER query.
alter table table_name add column_name data_type;
For example, if we consider the table employee we can write the query as:
mysql>alter table employee add city varchar(25) not null;
by this query we see that a new column E_City has been added in table Employee.Further you can also insert values in column city by using update query.