I can't seem to be able to create foreign keys. Here are my create
procedures and the error I am receiving.
CREATE TABLE `test1` (
`a_id` smallint(6) NOT NULL default '0',
PRIMARY KEY (`a_id`),
KEY `a_id` (`a_id`)
) TYPE=InnoDB;
CREATE TABLE `test2` (
`b_id` smallint(6) NOT NULL
You have several problems.
Both tables have duplicate keys.
You don't have a (c_id) key in table2 to add a constraint to.
William Hambleton wrote:
I can't seem to be able to create foreign keys. Here are my create
procedures and the error I am receiving.
CREATE TABLE `test1` (
`a_id`