RE: Link between tables.

2001-11-14 Thread Rick Emery
Question 2: You MUST enforce referential integrity until MYSQL 4.x intorduces functioning FOREIGN keys -Original Message- From: Venugopal Allavatam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 6:03 PM To: [EMAIL PROTECTED] Subject: Link between tables. Hello All, I need your hel

Link between tables.

2001-11-13 Thread Venugopal Allavatam
Hello All, I need your help with the following: I have two tables: create table_no1 ( key_no1 int unsigned auto_increment not null, field_no1 int unsigned not null ); create table_no2 ( key_no1 int unsigned not null, key_no2 int unsigned primary key auto_increment not null, field_no2 int unsign