kayamboo,
Thursday, October 10, 2002, 3:25:38 AM, you wrote:
k> If suppose my table has thousands of records, is it possible to create a
k> new table without a foreign key constraint, and then copy the existing data
k> with the foreign key constraint to the new one ?
Sure.
--
For technical
>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 9:15 PM
Subject: re: drop constraint in innodb
> kayamboo,
> Wednesday, October 09, 2002, 8:45:39 AM, you wrote:
>
> k> ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES
> k> Syoyu_db( Code,
Is there any other way to do this in a table with thousands of records.
- Original Message -
From: "Heo, Jungsu" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 8:50 PM
Subject: Re: d
kayamboo,
Wednesday, October 09, 2002, 8:45:39 AM, you wrote:
k> ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES
k> Syoyu_db( Code, Kana) ON DELETE CASCADE ;
k> works fine.
k> But how to drop the constraint or modify the constraint ?
k> Simply changing ADD to DROP or MODI
Last week, I posted a message related to this.
Heikki (InnoDB Developer) said "sorry, DROP CONSTRAINT is not implemented yet."
- Original Message -
From: "kayamboo" <[EMAIL PROTECTED]>
To: "list mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 2:45 PM
Subject: drop constrain