mysql重命名表,建立外键,增、删、改列名实例

##mysql重命名表,建立外键,增、删、改列名实例

##增加到某个字段之后
alter table tb_nippon_mms_info add province varchar(50) default null after retCode;
alter table tb_nippon_mms_info add city varchar(50) default null after province;

##增加到某个字段之前
alter table tb_nippon_mms_info add province varchar(50) default null before retCode;
alter table tb_nippon_mms_info add city varchar(50) default null before province;


##删除名字为states的列
alter table tb_nine_integral_mo_info drop  column states ;

##改变手机号码字段为约束键
alter table business.tb_nine_ticket_popedom change phone  phone  varchar(50)  not null unique;

##改变列名flag为states
alter table tb_nine_integral_mo_info change flag  states tinyint(1);


–重命名表
rename table t_softwareport to software_port;

–建立外键
alter table software_port add constraint fk_software_port_softwareprocessid foreign key (softwareprocessid)
references software_process (id) on delete restrict on update restrict;