답변 1개
아래 문법을 사용하시면 됩니다.< br> < br> ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]< br> < br> alter_specification:< br> ADD [COLUMN] create_definition [FIRST | AFTER column_name ]< br> or ADD [COLUMN] (create_definition, create_definition,...)< br> or ADD INDEX [index_name] (index_col_name,...)< br> or ADD PRIMARY KEY (index_col_name,...)< br> or ADD UNIQUE [index_name] (index_col_name,...)< br> or ADD FULLTEXT [index_name] (index_col_name,...)< br> or ADD [CONSTRAINT symbol] FOREIGN KEY index_name (index_col_name,...)< br> [reference_definition]< br> or ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}< br> or CHANGE [COLUMN] old_col_name create_definition< br> or MODIFY [COLUMN] create_definition< br> or DROP [COLUMN] col_name< br> or DROP PRIMARY KEY< br> or DROP INDEX index_name< br> or RENAME [TO] new_tbl_name< br> or ORDER BY col< br> or table_options< br> < br>
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인