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
