alter table table_name add(col type); update table_name set col = 'value'; alter table table_name modify(col (type) not null);