[MYSQL] probléme de création de la table
Bonjour a tous :),
svp signaler moi le probléme (dans la table x ):
create table a(
id int
);
create table b(
id int
);
create table x(
id int,
id1 int,
constraint foreign key(id) references a(id) on delete cascade,
constraint foreign key(id1) references b(id) on delete cascade
);
merci d'avance
--
To Be Or Not To Be , Marwen
svp signaler moi le probléme (dans la table x ):
create table a(
id int
);
create table b(
id int
);
create table x(
id int,
id1 int,
constraint foreign key(id) references a(id) on delete cascade,
constraint foreign key(id1) references b(id) on delete cascade
);
merci d'avance
--
To Be Or Not To Be , Marwen
1 réponse
-
create table a(
id int(11) unsigned auto_increment primary key
)engine=innoDB;
create table b(
id int(11) unsigned auto_increment primary key
)engine=innoDB;
create table x(
idx int(11) unsigned auto_increment primary key,
ida int(11) unsigned,
idb int(11) unsigned,
foreign key (ida) references a(id)
on delete cascade on update cascade,
foreign key (idb) references b(id)
on delete cascade on update cascade
)engine=innoDB;
Voila ça devrait fonctionner.
++
