Introduction - If you have any usage issues, please Google them yourself
alter table tbl_name add col_name type for example, to form an increase in weight mysql> alter table pet add weight int Remove Columns alter table tbl_name drop col_name For example, the deletion of column weight: mysql> alter table pet drop weight change out alter table tbl_name modify col_name type for example, the type of weight change: mysql> alter table pet modify weight samllint Another method is: alter table tbl_name change old_col_name col_name type for example: mysql> alter table pet change weight weight samllint to the column name mysql> alter table pet change weight wei renamed to table alter table tbl_name rename new_tbl for example, changed its name to the pet table animal mysql> alter table pet rename animal