Here's info about the error code: Error code 150: Unknown error: 150 150 = Foreign key constraint is incorrectly formed
Here's info on InnoDB foreign keys: http://www.mysql.com/doc/en/SEC459.html
At 16:33 +0000 3/24/03, Luis Matos Lima wrote:
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]
--
Jeff Shapiro, Colorado Springs, CO, USA
At work I *have* to use a Windows machine, at home I *get* to use a Mac.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]