MySQL adds a field: altertable 'user _ movement_log 'comment 'regionid' (after which field is added) Delete the field: altertable 'user _ movement_log' dropcolumnGatewayid adjust the field order: ALTERTABLE 'user _ movement_lo
MySQL adds a field: alter table 'user _ movement_log 'Add column GatewayId int not null default 0 AFTER 'regionid' (AFTER which field is added) Delete the field: alter table 'user _ movement_log 'drop column Gatewayid: alter table 'user _ movement_lo
Add a MySQL field:
Alter table 'user _ movement_log 'Add column GatewayId int not null default 0 AFTER 'regionid' (AFTER which field is added)
Delete field:
alter table `user_movement_log` drop column Gatewayid
Adjust the field order:
Alter table 'user _ movement_log 'CHANGE '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 alter table t2 add d timestamp; alter table infos add ex tinyint not null default '0 '; // Delete the alter table t2 drop column c; // rename the alter table t1 change a B integer ;// Alter table t1 change B bigint not null; alter table infos change list tinyint not null default '0'; // rename alter table t1 rename t2; add the index mysql> alter table tablename change depno int (5) not null; mysql> alter table tablename add index name (field name 1 [, field name 2…]); Mysql> alter table tablename add index emp_name (name); add primary keyword index mysql> alter table tablename add primary key (id ); add the index mysql> alter table tablename add unique emp_name2 (cardnumber) with the unique restrictions; delete an index mysql> alter table tablename drop index emp_name; modify the table:
Add field:
Mysql> alter table table_name ADD field_name field_type; modify the original field name and type: mysql> alter table table_name CHANGE old_field_name new_field_name field_type; Delete field: mysql> alter table table_name DROP field_name;