| 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 Key | Luis Matos Lima | 24 Mar |
| • Re: Foreign Key | Ernie Hershey | 24 Mar |
| • Re: Foreign Key | Jeff Shapiro | 24 Mar |
| • Re: Foreign Key | Ernie Hershey | 24 Mar |
