[DB][MySQL] add column

ALTER TABLE T_TX_DOC ADD COLUMN SUP_DT varchar(8) COMMENT '보완요청일' AFTER DUE_DT;

ALTER TABLE T_TX_DOC ADD COLUMN SUP_MEMO mediumtext COMMENT '보완요청사유' AFTER SUP_DT;

ALTER TABLE T_TX_DOC ADD COLUMN RQ_TP varchar(10) COMMENT '요청유형' NOT NULL  AFTER SUP_MEMO;

 

ALTER TABLE [테이블명] ADD COLUMN [추가되는 컬럼명] [데이터타입] COMMENT ['코멘트명'] NOT NULL

AFTER [추가될 컬럼 앞의 컬럼명];