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`
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 (
