List:General Discussion« Previous MessageNext Message »
From:Luis Matos Lima Date:March 24 2003 4:33pm
Subject:Foreign Key
View as plain text  
one.

CREATE TABLE tab3( 
cod1 int( 3 ) NOT NULL ,
cod2 int( 3 ) NOT NULL ,
PRIMARY KEY ( cod1, cod2 ) ,
FOREIGN KEY ( cod1 ) REFERENCES tab1( cod1 ) ON UPDATE 
CASCADE ON DELETE CASCADE ,
FOREIGN KEY ( cod2 ) REFERENCES tab2( cod2 ) ON UPDATE 
CASCADE ON DELETE CASCADE 
) TYPE = INNODB 

i receive a message error like this

Mensagens do MySQL : 
Can't create table '.\test\tab3.frm' (errno: 150)

know how to slove this problem.




-------------------------------------------------
Thread
Foreign KeyLuis Matos Lima24 Mar
  • Re: Foreign KeyErnie Hershey24 Mar
  • Re: Foreign KeyJeff Shapiro24 Mar
Re: Foreign KeyErnie Hershey24 Mar