ROTECTED]>
Sent: Sunday, September 29, 2002 10:24 PM
Subject: Re: Problem on "ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY.."
> Jungsu,
>
> - Original Message -
> From: ""Heo, Jungsu"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
&g
Jungsu,
- Original Message -
From: ""Heo, Jungsu"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, September 28, 2002 9:34 AM
Subject: Problem on "ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY.."
> Hello.
>
> I have
Sorry, I missed PARENT's COLUMNs.
Corrects.
ALTER TABLE CONS_CHILD ADD FOREIGN KEY CONS_CHILD_FK ( A , B ) REFERENCES
CONS_PARENT(A, B ) on delete cascade ;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> SHOW CRE
Hello.
I have a problem on "ALTER TABLE ... ADD FOREIGN KEY".
I'm using InnoDBs, and I wanna create Foreign Key after table has been created.
But, 'ALTER TABLE .. ADD FOREIGN KEY" does not work.
Manual says :
The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do anything
And in my
