Re: foreign keys: Cannot create InnoDB table

2009-08-20 Thread wabiko.takuma
ATUS \G > > And look for the "LATEST FOREIGN KEY ERROR" section. It'll explain the > reason for the (errno: 150) message. > > Regards, > Gavin Towey > > -Original Message- > From: wabiko.takuma [mailto:wab...@sysrdc.ns-sol.co.jp] > Sent: Fr

foreign keys: Cannot create InnoDB table

2009-08-14 Thread wabiko.takuma
Hi, All, I can't create InnoDB table with foreign key constraints using more than 3 colmuns. When I create table `test_fk`.`tbl1`, it gives me: Can't create table 'test_fk.tbl1' (errno: 150) why? CREATE TABLE syntax looks perfectly right to me. Any suggestions are welcome. Thank you, wabi