MySQL List of additions and deletions to change

Add a column to an existing table ALTER TABLE name add column Name column Type column property ... Default at the end of the table

Add a column to an existing table ALTER TABLE name add column Name column Type column Properties ... after column name (will appear after the specified column)

Delete a column in an existing table ALTER TABLE name drop column name

Modify a column in an existing table ALTER TABLE name change original column name new column Name column Type column property ...

Modify a column in an existing table ALTER TABLE name modify the original column Name column type column Properties ... (Modify cannot modify column name)

To view the structure of a table desc table name

MySQL List of additions and deletions to change