From: Peter Brawley
Date: April 6 2009 3:07pm
Subject: Re: One to many relationship
List-Archive: http://lists.mysql.com/mysql/217002
Message-Id: <49DA1A95.5020004@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

Abdul,

Is this what you mean?

CREATE TABLE Table1 (
 table1_id INT UNSIGNED PRIMARY KEY AUTO INCREMENT,
entrydate TIMESTAMP
)ENGINE=INNODB;
CREATE TABLE table2 (
 table2_id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
 table1_id INT UNSIGNED NOT NULL,
 entrydate TIMESTAMP,
FOREIGN KEY(table1_id) REFERENCES table1(table1_id)
)ENGINE=INNODB;

After this, the DB engine will ensure that any table1_id value you try 
to insert in table2 actually exists in table1. See the manual page for 
foreign keys.

PB

-----

abdulazeez alugo wrote:
>  
>
>
>
>
> Hello all,
> I'm trying to design a relational database where two tables link to each other through unique id sa below
> Table 1
> table1_id INT UNSIGNED NOT NULL AUTO INCREMENT,
> entrydate TIMESTAMP
>  
> Table2
> table2_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
> table1_id INT UNSIGNED NOT NULL,
> entrydate TIMESTAMP,
>  
> Sorry. The above is just a rough sketch of what I have here and I hope you understand what I'm trying to portray but the value of table1_id inside table2 keeps returning the value 0 thereby it doesn't correspond with any value in table1_id in table1.
> Please I need help on this issue.
> Thanks in anticipation of your prompt response.
>
>
> _________________________________________________________________
> Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.
>
> http://www.microsoft.com/windows/windowslive/products/photos.aspx
>   
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 8.0.238 / Virus Database: 270.11.42/2042 - Release Date: 04/05/09 10:54:00
>
>