Hello, there. I have a question about altering table which has foreign key constraints.
MySQL manual says that : "In InnoDB versions < 3.23.50 ALTER TABLE or CREATE INDEX should not be used in connection with tables which have foreign key constraints or which are referenced in foreign key constraints: .. (omitted) .. A CREATE INDEX statement is in MySQL processed as an ALTER TABLE, and these restrictions apply also to it. " on http://www.mysql.com/doc/en/SEC457.html But, how abount InnoDB versions >= 3.23.50? Version 4.0.11 still cannot alter referencing table and referenced table? What's the safe query in below lits (MySQL 4.0.11) ? * alter referencing table * alter referenced table * create index on referencing table * create index on referenced table. When I have used MySQL 4.0.10 If I alter referencing and referenced table several times, sometimes I could not execute a query on those tables even "drop table...." (So I rebuilded entire InnoDB ;-( ) Thank you for advanced answer! ########################## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.com Filter : sql --------------------------------------------------------------------- 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
