MySQL add field:
ALTER TABLE ' User_movement_log '
add column Gatewayid int not null default 0 after ' RegionID ' (added after which field)
To delete a field:
ALTER TABLE ' user_movement_log ' drop column Gatewayid
To adjust the order of fields:
ALTER TABLE ' User_movement_log ' change ' Gatewayid ' gatewayid ' int not null default 0 after RegionID//PRIMARY key ALTER TABLE Tabelname Add new_field_id Int (5) unsigned default 0 NOT NULL auto_increment, add primary key (NEW_FIELD_ID);//Add a new column A
Lter table T2 add d timestamp; ALTER TABLE infos add ex tinyint NOT null default ' 0 '//delete column ALTER TABLE t2 drop column c;//rename column ALTER TABLE T1 change
A b integer;
Changing the type of the column ALTER TABLE T1 change b b bigint not null;
ALTER TABLE infos change list tinyint not null default ' 0 ';
Rename table alter TABLE t1 rename T2 gazzo mysql> ALTER TABLE tablename change Depno int (5) is not null;
Mysql> ALTER TABLE tablename ADD index index name (field name 1[, field Name 2 ...]); Mysql> ALTER TABLE tablename Add index Emp_name (name), plus the index of the primary key mysql> ALTER TABLE TableName ADD PRIMARY key (ID); The index of the unique constraint mysql> ALTER TABLE tablename add unique emp_name2 (cardnumber); Delete an index mysql>alter table tablename Drop Index Emp_name Modify Table:
Add fields:
Mysql> ALTER TABLE table_name ADD field_name Field_type; Modify the original field name and type:
mysql> ALTER TABLE table_name change OLD_FI Eld_name new_field_name field_type; Delete field:
mysql> ALTER TABLE table_name DROP field_name;