re: Re: drop constraint in innodb

2002-10-10 Thread Egor Egorov 

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 support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

drop constraint in innodb

2002-10-09 Thread kayamboo 
sql, query


Hi Folks

ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES
Syoyu_db( Code, Kana) ON DELETE CASCADE ;

works fine.

But how to drop the constraint or modify the constraint ?
Simply changing ADD to DROP or MODIFY throws errors


regards



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: drop constraint in innodb

2002-10-09 Thread Heo, Jungsu 

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 constraint in innodb


 sql, query


 Hi Folks

 ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES
 Syoyu_db( Code, Kana) ON DELETE CASCADE ;

 works fine.

 But how to drop the constraint or modify the constraint ?
 Simply changing ADD to DROP or MODIFY throws errors


 regards



 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: drop constraint in innodb

2002-10-09 Thread Egor Egorov 

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 MODIFY throws errors

Curretly you can't drop only foreign key constarints. You should
re-create a table.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: drop constraint in innodb

2002-10-09 Thread kayamboo 
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: drop constraint in innodb


 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 constraint in innodb


  sql, query
 
 
  Hi Folks
 
  ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES
  Syoyu_db( Code, Kana) ON DELETE CASCADE ;
 
  works fine.
 
  But how to drop the constraint or modify the constraint ?
  Simply changing ADD to DROP or MODIFY throws errors
 
 
  regards
 
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
[EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: drop constraint in innodb

2002-10-09 Thread kayamboo 
HI

  If suppose my table has thousands of records, is it possible to create a
new table without a foreign key constraint, and then copy the existing data
with the foreign key constraint to the new one ?


regards
- Original Message -
From: "Egor Egorov" [EMAIL PROTECTED]
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, 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 MODIFY throws errors

 Curretly you can't drop only foreign key constarints. You should
 re-create a table.



 --
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Egor Egorov
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com




 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php