1、 在建表时建立外键
create table A( Aid int primary key,...)
create table B( Bid int primary key, Aid int, ... ... foreign key (Aid) references A (Aid) on delete ... on update ... )
2. 对已有的表增加外键
alter table table_name add constraint fk_name foreign key (column_name_from) references other_table_name(column_name_to) on update cascade;
外键是”fk_name”, 如果 column_name_to 没有索引, 则会建立一个名为”fk_name";
3、查看外键的名字
show create table table_name;
4、删除外键
alter table table_name drop foreign key fk_name;