I agree with you. If there is no index already on the referenced fields then add one. By adding a foreign key you are already altering the table why not just finish the job.
-----Original Message----- From: Natale Babbo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 8:58 AM To: Okan CIMEN; [EMAIL PROTECTED] Subject: Re: innofb foreign keys problem many thanks for your reply. 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? Thanks. --- Okan CIMEN <[EMAIL PROTECTED]> ha scritto: > There are no other way > you have to create the index first > > ----- Original Message ----- > From: "Natale Babbo" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, January 14, 2003 5:41 PM > Subject: innofb foreign keys problem > > > > # --------- 3rd post ------------- # > > # --------- PLEASE HELP ---------- # > > > > hi to all, > > > > is it still true that mysql/innodb needs explicit > > index creation on foreign keys? > > why can't i use a standard syntax for foreign keys creations? > > i have a database schema (ddl) with over 50 tables > and > > i was trying to create the database on mysql when > i > > receive a lot of errors like this: > > > > ERROR 1005: Can't create table .... (errno 150) > > > > how can i create the database without creating > > explicitly an index on each foreign keys of my > > database? > > > > any suggestions are appreciated. > > thanks to all. > > > > > ______________________________________________________________________ > > Yahoo! Cellulari: loghi, suonerie, picture message > per il tuo telefonino > > > http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.h tml > > > > > --------------------------------------------------------------------- > > 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 > > > > > ______________________________________________________________________ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.h tml --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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