mysql一对一关系,MySQL中的一对一关系

I'm trying to make a one to one relationship in a MySQL DB. I'm using the InnoDB engine and the basic table looks like this:

CREATE TABLE `foo` (

`fooID` INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,

`name` TEXT NOT NULL

)

CREATE TABLE `bar` (

`barName` VARCHAR(100) NOT NULL,

`fooID` INT(11) NOT NULL PRIMARY KEY,

CONSTRAINT `contact` FOREIGN KEY (`fooID`) REFERENCES `foo`(`fooID`)

)

Now once I have set up these I alter the foo table so that the fooID also becomes a foreign key to the fooID in bar.

The only issue I am facing with this is that there will be a integrity issue when I try to insert into either.

I would like some help, thanks.

解决方案

A true one-to-one relationship in a relational database is best done by adding a column; If the data in these two tables is always required for every record, then the table should be defined as foo (fooID, name, barname).