Posted by jason.m.ho on 06/23/06 07:58

Why does creating the following table give me the error: ERROR 1005
(HY000): Can't create table (errno: 150)

CREATE TABLE orderProducts (
orderID integer(10),
productID integer(10),
quantity integer(10),
PRIMARY KEY (orderID, productID),
FOREIGN KEY (orderID) REFERENCES orders (orderID),
FOREIGN KEY (productID) REFERENCES products (productID)
);

Can i not say that attributes that are part of the primary key are also
foreign keys?

- Jason

[Back to original message]