Constraints - Error or Bug????

Hi all, I just wonder. I have tried this example from www.mysql.org Doc. CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE

Constraints - Error or Bug???? - Part II

Hi all, It seems that some is misunderstanding my problem, so i try to re-write my problem again. I just wonder. I have tried this example from www.mysql.org Doc. CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind

Re: Constraints - Error or Bug???? - Part II

MySQL wrote: Hi all, It seems that some is misunderstanding my problem, so i try to re-write my problem again. I just wonder. I have tried this example from www.mysql.org Doc. CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT,

Re: Constraints - Error or Bug????

- From: MySQL [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, May 31, 2002 7:45 PM Subject: Constraints - Error or Bug Hi all, I just wonder. I have tried this example from www.mysql.org Doc. CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE