Answers for "alter table add default"

alter table add column with default value

ALTER TABLE Protocols
ADD ProtocolTypeID int NOT NULL DEFAULT(1)

how to add default constraint in mysql

ALTER TABLE "name_table" ALTER "name_column" 
SET DEFAULT value_default;

set default column value sql

Name Varchar(255) default "Fred"

add column alter table default value

ALTER TABLE PERSON
ADD IS_ACTIVE VARCHAR2(1) DEFAULT 'N' NOT NULL