yes -- you need to create indexes on foreign key colums. it would be better if one of the following 2 things happened instead.
1. foreign key creation failed if no index existed. 2. indexes were created automatically it's more dangerous than actually not having foreign keys as it stands since it's easy to *think* your app is working correctly when it could in fact be trashing referential integrity. > > From: Natale Babbo <[EMAIL PROTECTED]> > Subject: innofb foreign keys problem > Date: 15/01/2003 2:41:06 > To: [EMAIL PROTECTED] > > # --------- 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.html > > --------------------------------------------------------------------- > 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 > > This message was sent through MyMail http://www.mymail.com.au --------------------------------------------------------------------- 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