Hi,

I'm trying to create a primary key with 2 foreign keys as follows :

create Table Achats(
idContrat INT NOT NULL,
idProduit VARCHAR(12) NOT NULL,
quantite INT NOT NULL,
PRIMARY KEY(idContrat,idProduit),
INDEX (idContrat,idProduit),
FOREIGN KEY(idContrat) REFERENCES Contrats(IdContrat) ON UPDATE CASCADE ON DELETE CASCADE,
FOREIGN KEY(idProduit) REFERENCES Produit(idProduit) ON UPDATE CASCADE ON DELETE CASCADE) TYPE=INNODB;

If anyone knows what's wrong ???

thank you all.

Perhaps you could tell us what errors you are getting? And of course you already created the other tables that the foreign keys reference?

the foreign key fields need to be indexed

yo uhave two indexes on this table --

PRIMARY KEY(idContrat,idProduit)
INDEX (idContrat,idProduit)

each foreign key needs an index

i think (not sure, don't have time to test) that either of the above compound indexes will suffice for the index for the fk on idContrat, but the fk on idProduit does not have an index that it can use

Here is some more good information about Foreign Keys.

http://dev.mysql.com/doc/mysql/en/In...nstraints.html