Re: RE : Dropping foreing key without losing data
On Fri, Jan 31, 2003 at 08:46:53AM +0100, Webmaster LLBfrance wrote: > Hello Zak, > > Thanks for your response. > I try the way you told me, but it seems there is > another problem : > The old foreign keys always exist. > In consequence, there are double references. > > How can i resolve that problem ? Ah... e... let me do some testing. In the past, simply running alter table would drop the foreign keys. Now that things are different, I will have to see what works (or ask Heikki about it) Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Show the configuration options set in the server % mysqld --print-defaults Sincere Choice: Supporting a Fair Software Market (http://sincerechoice.org) - 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 : Dropping foreing key without losing data
Hello Zak, Thanks for your response. I try the way you told me, but it seems there is another problem : The old foreign keys always exist. In consequence, there are double references. How can i resolve that problem ? Thanks in advance. JeanClaude -Message d'origine- De : Zak Greant [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 30 janvier 2003 23:16 À : Webmaster LLBfrance Cc : [EMAIL PROTECTED] Objet : Re: Dropping foreing key without losing data On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote: > Hello, > > Can you tell me how to drop or desactivate a foreign key without > losing any data in SQL for MySQL 3.23.51 ? Hello JeanClaude, Unfortunately, foreign keys cannot currently be conveniently dropped. :( The InnoDB developer plans to implement this in the near future. The only option currently is to recreate the table structure, move the data into the new table, drop the old table and then rename the table. Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: San Francisco, February 03-07, 2003 Visit http://mysql.com/training for more information GNU/Free Software Foundation (http://www.gnu.org) - 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: Dropping foreing key without losing data
On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote: > Hello, > > Can you tell me how to drop or desactivate a foreign key without > losing any data in SQL for MySQL 3.23.51 ? Hello JeanClaude, Unfortunately, foreign keys cannot currently be conveniently dropped. :( The InnoDB developer plans to implement this in the near future. The only option currently is to recreate the table structure, move the data into the new table, drop the old table and then rename the table. Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: San Francisco, February 03-07, 2003 Visit http://mysql.com/training for more information GNU/Free Software Foundation (http://www.gnu.org) - 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
Dropping foreing key without losing data
Hello, Can you tell me how to drop or desactivate a foreign key without losing any data in SQL for MySQL 3.23.51 ? Thanks in advance. JeanClaude - 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