mysql添加外健关联

1、建表的时候添加外健关联

create table table_name(

ID int(11) primary key,

TagID int(11) not null,

constraint `FK_Table1_Table` foreign key(TagID) references Table1(ID)

)engine=InnoDB default charset=utf8;

2、建立表以后添加外健关联

alter table table_name add constraint `FK_Table_table_name` foreign key(TagID) references Table(ID);