MySQL表修改的实际操作语法描述

ALTER [IGNORE] TABLE tbl_name 
alter_specification [, alter_specification] ... 
alter_specification: 
ADD [COLUMN] column_definition [FIRST | AFTER col_name ] 
| ADD [COLUMN] (column_definition,...) 
| ADD INDEX [index_name] [index_type] (index_col_name,...) 
| ADD [CONSTRAINT [symbol]] 
PRIMARY KEY [index_type] (index_col_name,...) 
| ADD [CONSTRAINT [symbol]] 
UNIQUE [index_name] [index_type] (index_col_name,...) 
| ADD [FULLTEXT|SPATIAL] [index_name] (index_col_name,...) 
| ADD [CONSTRAINT [symbol]] 
FOREIGN KEY [index_name] (index_col_name,...) 
[reference_definition] 
| ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT} 
| CHANGE [COLUMN] old_col_name column_definition 
[FIRST|AFTER col_name] 
| MODIFY [COLUMN] column_definition [FIRST | AFTER col_name] 
| DROP [COLUMN] col_name 
| DROP PRIMARY KEY 
| DROP INDEX index_name 
| DROP FOREIGN KEY fk_symbol 
| DISABLE KEYS 
| ENABLE KEYS 
| RENAME [TO] new_tbl_name 
| ORDER BY col_name 
| CONVERT TO CHARACTER SET charset_name [COLLATE collation_name] 
| [DEFAULT] CHARACTER SET charset_name [COLLATE collation_name] 
| DISCARD TABLESPACE | IMPORT TABLESPACE | table_options 
| partition_options 
| ADD PARTITION partition_definition 
| DROP PARTITION partition_names 
| COALESCE PARTITION number 
| REORGANIZE PARTITION partition_names INTO (partition_definitions) 
| ANALYZE PARTITION partition_names 
| CHECK PARTITION partition_names 
| OPTIMIZE PARTITION partition_names 
| REBUILD PARTITION partition_names 
| REPAIR PARTITION pa