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 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..) when I try to define > `cid` as a foreign key to country.id > > country.id and countrytext.cid are both smallint(5) > > Any help? > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
