MySQL Modify data sheet

ALTER [IGNORE] table Tb_name alter_spec,alter_spec ....

Alter_specification:

ADD [COLUMN] create_definition [first| After column_name]--Add a new field

Add index [index name] (index_col_name)--Adds an indexed name

Add PRIMARY Key (index_col_name)--Adding a primary key name

Add unique [index_name] (index_col_name)--Adding a unique index

ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}--Modify the field name

Change [COLUMN] old_col_name create_definition--Modify field type

MODIFY [COLUMN] create_definition--Modify sentence definition field

Drop [COLUMN] col_name--delete field name

Drop PRIMARY Key--Delete primary Key name

Drop INDEX Index_name--Remove the name

RENAME [As] new_tb_name--Change table name

MySQL Modify data sheet