Foreign Key Constant Problem

#1

In my main table I have:
CREATE TABLE maintable {
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
.....
linkid INT UNSIGNED,
....
....
lastfield VARCHAR(10),
PRIMARY KEY(id),
INDEX (linkid ),
FOREIGN KEY (linkid ) REFERENCES subtable(linkid )
) ENGINE=INNODB;

CREATE TABLE subtable (
linkid INT UNSIGNED NOT NULL AUTO_INCREMENT,
linkvalue VARCHAR(20),
PRIMARY KEY (linkid)
) ENGINE=INNODB;

I keep getting an error:
"Foreign key constraint is incorrectly formed"

Appreciate any help on what I'm doing wrong..

Thanks...

Bruce

#2

On 12/19/2010 12:29 PM, bruce wrote:

Quote:

In my main table I have:
CREATE TABLE maintable {
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
....
linkid INT UNSIGNED,
...
...
lastfield VARCHAR(10),
PRIMARY KEY(id),
INDEX (linkid ),
FOREIGN KEY (linkid ) REFERENCES subtable(linkid )
) ENGINE=INNODB;

CREATE TABLE subtable (
linkid INT UNSIGNED NOT NULL AUTO_INCREMENT,
linkvalue VARCHAR(20),
PRIMARY KEY (linkid)
) ENGINE=INNODB;

I keep getting an error:
"Foreign key constraint is incorrectly formed"

Appreciate any help on what I'm doing wrong..

Thanks...

Bruce

Does subtable actually exist when you create maintable?

I'm assuming this isn't the actual SQL you're using. Try posting the
exact statements (i.e. cut/paste) you're using.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#3

On Dec 19, 3:01*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:

Quote:

On 12/19/2010 12:29 PM, bruce wrote:

In my main table I have:
CREATE TABLE maintable {
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
....
linkid INT UNSIGNED,
...
...
lastfield VARCHAR(10),
PRIMARY KEY(id),
INDEX (linkid ),
FOREIGN KEY (linkid ) REFERENCES subtable(linkid )
) ENGINE=INNODB;

CREATE TABLE subtable (
linkid INT UNSIGNED NOT NULL AUTO_INCREMENT,
linkvalue VARCHAR(20),
PRIMARY KEY (linkid)
) ENGINE=INNODB;

I keep getting an error:
"Foreign key constraint is incorrectly formed"

Appreciate any help on what I'm doing wrong..

Thanks...

Bruce

Does subtable actually exist when you create maintable?

I'm assuming this isn't the actual SQL you're using. *Try posting the
exact statements (i.e. cut/paste) you're using.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck... (AT) attglobal (DOT) net
==================

I discovered my problems when I was preparing to copy/paste the actual
sql. It was a "typo", namely my subtable is named "states" but I
forgot the "s" and used "state".

Thanks...

Bruce

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Foreign Key Constant Problem

comp.databases.mysql comp.databases.mysql

Foreign Key Constant Problem - 12-19-2010 , 11:29 AM

Re: Foreign Key Constant Problem - 12-19-2010 , 02:01 PM

Re: Foreign Key Constant Problem - 12-19-2010 , 05:45 PM