Hello.
Please, send the output of the following statements:
SHOW CREATE TABLE country;
SHOW CREATE TABLE lang;
Include the CREATE statement for countrylang table and exact error number.
Guy Brom wrote:
I have the following innoDb tables:
country has `id` as PK
lang has `id` as
I have the following innoDb tables:
country has `id` as PK
lang has `id` as PK
I want to have a 3rd innoDb table:
countrylang with `cid,lang` as compound key with both `cid` and `lang` as
foreign (cascade-delete) keys to the master tables.
However mysql throws error (Cannot create table..)
Hi Guy,
Use SHOW INNODB STATUS and check foreign key error at there
Good luck
Guy Brom wrote:
I have the following innoDb tables:
country has `id` as PK
lang has `id` as PK
I want to have a 3rd innoDb table:
countrylang with `cid,lang` as compound key with both `cid` and `lang`
as foreign