Add columns:Alter Tabletable_nameAddNamevarchar( -);Alter Tabletable_nameAddNamevarchar( -) after ID;Alter Tabletable_nameAddNamevarchar( -) First; Modify the column name:Alter TableTABLE_NAME Change name Namevarchar(Ten); #change可改名字与字段类型mysql> Alter TableA change UID UIDint; Query OK,0Rows Affected (0.04sec) Records:0Duplicates:0Warnings:0Alter TableTABLE_NAME Modify Nameint; #modify只改字段类型mysql> descA;+-------+---------+------+-----+---------+-------+|Field|Type| Null | Key | Default |Extra|+-------+---------+------+-----+---------+-------+|Namea| Char(1)|YES| | NULL | ||Id| int( One)|YES| | NULL | ||Uid| int( One)|YES| | NULL | |+-------+---------+------+-----+---------+-------+3Rowsinch Set(0.01sec) MySQL>MySQL>MySQL> Alter TableA modify UIDvarchar(1); Query OK,0Rows Affected (0.07sec) Records:0Duplicates:0Warnings:0MySQL> descA;+-------+------------+------+-----+---------+-------+|Field|Type| Null | Key | Default |Extra|+-------+------------+------+-----+---------+-------+|Namea| Char(1)|YES| | NULL | ||Id| int( One)|YES| | NULL | ||Uid| varchar(1)|YES| | NULL | |+-------+------------+------+-----+---------+-------+3Rowsinch Set(0.01sec) MySQL>To delete a column:Alter Tabletable_nameDropcolumn_name, #手册help modify;
MySQL column in the additions and deletions to change