Hi all,
I have installed MySql 4.1 in my system. when I tried to run Mysql , I
always gets this error.
Could not start MySql service on a local computer
Error 1067: the process terminated unexpectedly.
Any help is highly appreciated.
Regards,
Renish
----- Original Message -----
From: "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` 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 happens? I don't know if foreign keys can reference
itself like that, the best way to find out is to try it.
The create index statement will work but it's not going to be on the same
table.. don't know if that's a typo or what.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
