For add column:
Code:
ALTER TABLE table_name add COLUMN column_name varchar(30)
For add column after specific filed,
Code:
ALTER TABLE table_name add COLUMN column_name varchar(30) AFTER column_name
For add column at first
Code:
ALTER TABLE table_name add COLUMN column_name varchar(30)FIRST
<Snip>