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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org