mysql中alter命令的完整格式
时间: 2024-03-11 19:49:33 浏览: 15
MySQL中alter命令的完整格式如下:
```
ALTER [IGNORE] TABLE table_name
[alter_specification [, alter_specification] ...]
alter_specification:
ADD [COLUMN] column_definition [FIRST | AFTER column_name ]
ADD [COLUMN] ( column_definition, ... )
ADD {INDEX|KEY} [index_name] [index_type] (index_col_name, ...)
ADD {FULLTEXT|SPATIAL} [INDEX|KEY] [index_name] (index_col_name, ...)
ADD [CONSTRAINT [symbol]] FOREIGN KEY
[index_name] (index_col_name, ...)
reference_definition
ALTER [COLUMN] column_name {SET DEFAULT literal | DROP DEFAULT}
CHANGE [COLUMN] old_col_name new_col_name column_definition
[FIRST|AFTER column_name]
MODIFY [COLUMN] column_definition [FIRST | AFTER column_name]
DROP [COLUMN] column_name
DROP {INDEX|KEY} index_name
DROP FOREIGN KEY fk_symbol
DISABLE KEYS
ENABLE KEYS
RENAME [TO] new_table_name
```
其中,方括号表示可选项,大括号表示可选项集合,竖线表示选项之间的选择关系。