Re: Foreign key on multiple columns

[Peter Brawley]

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql