On Tue, 14 Jan 2003 16:41:06 +0100 (CET) Natale Babbo <[EMAIL PROTECTED]> wrote:
> # --------- 3rd post ------------- # > # --------- PLEASE HELP ---------- # > > hi to all, > > is it still true that mysql/innodb needs explicit > index creation on foreign keys? Yes > 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? > You can't -- _/ _/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] ----- _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ --------==* http://szukaj.wp.pl *==---------- --------------------------------------------------------------------- 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