MySQL Alter example

Alter Table' User_movement_log 'ADD columnGatewayidint  not NULL default 0After ' RegionID ' (which field is added later)Alter TableX_connectionAdd' FEX-N752 'varchar(Ten)default NULL;//PRIMARY KeyAlter TableTabelnameAddnew_field_idint(5) unsigneddefault 0  not NULLAuto_increment,Add Primary Key(new_field_id);//Add a new columnAlter TableT2AddDtimestamp; Alter TableInfosAddExtinyint  not NULL default '0';//Delete ColumnAlter TableT2Drop columnC;//Renaming ColumnsAlter TableT1 change a Binteger;//changing the type of a columnAlter TableT1 Change b bbigint  not NULL; Alter TableInfos change List Listtinyint  not NULL default '0';//Renaming a tableAlter TableT1 rename T2; Gazzo lead MySQL> Alter TableTableName Change Depno depnoint(5) not NULL; MySQL> Alter TableTableNameAdd IndexIndex name (field name 1[, field name 2 ...]); MySQL> Alter TableTableNameAdd Indexemp_name (name); Add primary key index MySQL> Alter TableTableNameAdd Primary Key(ID); Add a unique restriction index MySQL> Alter TableTableNameAdd Uniqueemp_name2 (cardnumber); Delete an index mysql>Alter TableTableNameDrop Indexemp_name; Modify table: Add field: MySQL> ALTER TABLEtable_nameADDfield_name Field_type; Modify the original field name and type: MySQL> ALTER TABLEtable_name Change old_field_name new_field_name field_type;eg:Alter TableDip_mr_log Change Map_output_byte map_output_bytebigintUnsignedDEFAULT '0'; Delete field: MySQL> ALTER TABLEtable_nameDROPField_name;

MySQL Alter example