: "Chris" <[EMAIL PROTECTED]>
To: "m i l e s" <[EMAIL PROTECTED]>
Cc: "MySQL"
Sent: Monday, October 09, 2006 4:25 PM
Subject: Re: Self References & Indexes
m i l e s wrote:
Hi,
Can anyone tell me if this is the correct syntax for a self reference
m i l e s wrote:
Hi,
Can anyone tell me if this is the correct syntax for a self reference &
Index ?
--> ALTER TABLE `RPI_CTYPE` ADD FOREIGN KEY (`RPI_CT_REPLCID`)
REFERENCES `RPI_CTYPE`(`RPI_CT_ID`);
--> CREATE INDEX RPI_H_REPLCID_idxfk ON RPI_HOW (RPI_H_REPLCID);
If you try it what ha
Hi,
Can anyone tell me if this is the correct syntax for a self reference
& Index ?
--> ALTER TABLE `RPI_CTYPE` ADD FOREIGN KEY (`RPI_CT_REPLCID`)
REFERENCES `RPI_CTYPE`(`RPI_CT_ID`);
--> CREATE INDEX RPI_H_REPLCID_idxfk ON RPI_HOW (RPI_H_REPLCID);
M i l e s.
--
MySQL General Mailing L