i´m having some trouble in creating a table like this 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 don´t understand why i acannot create it. I´m using mysql 4.0.12 in win98 wiht phpmyadmin 2.2.4 i receive a message error like this Mensagens do MySQL : Can't create table '.\test\tab3.frm' (errno: 150) Please help, i´m in a important project and i need to know how to slove this problem. ------------------------------------------------- Email Enviado utilizando o serviço MegaMail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]