On Wed, 17 Dec 2003 07:55 pm, Victoria Reznichenko wrote: > Mofeed Shahin <[EMAIL PROTECTED]> wrote: > > mysql> CREATE TABLE foo ( > > -> ID INT PRIMARY KEY, > > -> note VARCHAR(50), > > -> First_Name VARCHAR(50), > > -> Last_Name VARCHAR(50), > > -> FOO_ID INT, > > -> INDEX(FOO_ID), > > -> INDEX(First_Name, Last_Name), > > -> FOREIGN KEY (FOO_ID) REFERENCES foo(ID), > > -> FOREIGN KEY (First_Name, Last_Name) REFERENCES Blah > > (First_Name, Last_Name) > > -> ) TYPE=INNODB; > > ERROR 1005: Can't create table './moftest/foo.frm' (errno: 150) > > What is version of MySQL server? What default-character-set do you use?
MySQL version == 4.0.15. Charact set == latin1 Mof. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]