Sql: add a column to existing table and uniquely number them

alter table Example
add NewColumn int identity(1,1)

ALTER TABLE tableName ADD id MEDIUMINT NOT NULL AUTO_INCREMENT KEY

ALTER TABLE tableName ADD id SERIAL;
ALTER TABLE tableName ADD PRIMARY KEY (id);