I'm trying to create a bunch of tables in MySQL. I'm having problems creating
the following table :
CREATE TABLE foo(
ID INT PRIMARY KEY,
note VARCHAR(50),
FOO_ID INT,
FOREIGN KEY (FOO_ID) REFERENCES foo(ID)
) TYPE=INNODB;
The error I get is the following :
ERROR 1005: Can't create table './moftest/foo.frm' (errno: 150)
I found out that errno 150 means that it didn't like the Foreign key
constraint.
Does MySQL not support this type of Foreign Key constraint ?
Mof.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
