subject:"Self References Indexes"

Re: Self References Indexes

2006-10-09 Thread Chris

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

Re: Self References Indexes

2006-10-09 Thread Renish

: Chris [EMAIL PROTECTED] To: m i l e s [EMAIL PROTECTED] Cc: MySQL mysql@lists.mysql.com 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 Index ? -- ALTER TABLE `RPI_CTYPE

Self References Indexes

2006-10-03 Thread m i l e s

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