mysql设置外键级联

[朽木可雕]

表A        表B
aid        bid
aInfo      binfo
           aid

如何用alter 把 b中的aid设置成级联,我的b表中的aid不能删除重新建立

[ACMAIN_CHM]

create table a(aid int primaey,aInfo int) engine=innodb;
create table b(bid int primaey,binfo int,aid int) engine=innodb;
alter table b ADD FOREIGN KEY (aid) REFERENCES a (aid) ON DELETE CASCADE ON UPDATE CASCADE;

[朽木可雕]

[Quote=引用 1 楼 acmain_chm 的回复:]
create table a(aid int primaey,aInfo int) engine=innodb;
create table b(bid int primaey,binfo int,aid int) engine=innodb;
alter table b ADD FOREIGN KEY (aid) REFERENCES a (aid) ON DELETE CASCADE ON ……
[/Quote]


谢谢你的回答销路这么高,我上一个问题也是你回答的..