alter 명령 총정리

ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...] [ORDER BY col]



alter_specification:

ADD [COLUMN] create_definition [FIRST | AFTER column_name ]

or ADD [COLUMN] (create_definition, create_definition,...)

or ADD INDEX [index_name] (index_col_name,...)

or ADD PRIMARY KEY (index_col_name,...)