Alter is a DDL command,you can not manipulate the table using alter. Need to use either update or insert into query to fill other column values.