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... errrr... 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