I'm trying to create a foreign key on two columns but getting error...
Here's what I tried:
CREATE TABLE test2 ( ID INT NOT NULL AUTO_INCREMENT, col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (ID), CONSTRAINT fk FOREIGN KEY (col1, col2) REFERENCES test1(ID, ID) ON UPDATE CASCADE ON DELETE RESTRICT ) ENGINE=InnoDB;
But I get `ERROR 1005 (HY000): Can't create table 'DB.test2' (errno: 150)`
Mar 21
Peter Brawley Re: Foreign key on multiple columns
Mar 21, 2013; 09:44
Peter Brawley
Re: Foreign key on multiple columns
Mar 22
Abhishek Choudhary Re: Foreign key on multiple columns
Mar 22, 2013; 00:43
Abhishek Choudhary
Re: Foreign key on multiple columns
Mar 21
shawn green Re: Foreign key on multiple columns
Mar 21, 2013; 12:48
shawn green
Re: Foreign key on multiple columns
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!