> then i ask me: why mysql needs explicit creation > instead of create itself what it needs? > manually creating the index seems to be a big > complication (for big databases) and a waste of time. > don't you think so? > it's a bug or a wanted feature? why? I agree with you 100%.
A foreign key,as its name implies, should create automatically a key. I would it is a wanted feature. __ / \\ @ __ __ @ Adolfo Bello <[EMAIL PROTECTED]> / // // /\ / \\ // \ // Bello Ingenieria S.A, Presidente / \\ // / \\/ // // / // cel: +58 416 609-6213 /___//// / <_/\__\\//__/ // fax: +58 212 952-6797 www.bisapi.com // pager: www.tun-tun.com (# 609-6213) --------------------------------------------------------------------- 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