List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:March 21 2013 2:44pm
Subject:Re: Foreign key on multiple columns
View as plain text  
On 2013-03-21 8:12 AM, Norah Jones wrote:
> 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)`

Dupe reference column.

PB
>
>

Thread
Foreign key on multiple columnsNorah Jones21 Mar
  • Re: Foreign key on multiple columnsPeter Brawley21 Mar
    • Re: Foreign key on multiple columnsAbhishek Choudhary21 Mar
      • Re: Foreign key on multiple columnsshawn green21 Mar