Natale, please address these general questions to [EMAIL PROTECTED]
InnoDB requires that the indexes are created explicitly. It would require a change to MySQL to automate the creation of them. Without indexes foreign key checks would be very slow because then every check would have to do a table scan. Regards, Heikki Innobase Oy sql query ----- Original Message ----- From: "Natale Babbo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 5:52 PM Subject: please help me - problem with innodb foreign keys > # --------- PLEASE HELP ---------- # > > hi, > > i've a problem with innodb foreign keys creation as > following: > > 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. > Please help me. Many thanks. > > ______________________________________________________________________ > 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