[MYSQL] probléme de création de la tableFermé

Question

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

Configuration: Windows XP / Safari 534.30

prosthetiks · Answer

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.

++

[MYSQL] probléme de création de la table

1 réponse

Discussions similaires

Newsletters