MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:<greg55 Date:January 14 2003 9:42pm
Subject:Re: innofb foreign keys problem
View as plain text  
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 <natale_babbo75@stripped>
> Subject: innofb foreign keys problem
> Date: 15/01/2003 2:41:06
> To: mysql@stripped
> 
> # --------- 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 <mysql-thread129876@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-greg55=ozemail.com.au@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 

This message was sent through MyMail http://www.mymail.com.au


Thread
innofb foreign keys problemNatale Babbo14 Jan
  • Re: innofb foreign keys problemRafal Jank14 Jan
Re: innofb foreign keys problemNatale Babbo14 Jan
  • RE: innofb foreign keys problemRoss Davis - DataAnywhere.net14 Jan
  • Re: innofb foreign keys problemAdolfo Bello14 Jan
Re: innofb foreign keys problemgreg5514 Jan
Re: innofb foreign keys problemHeikki Tuuri16 Jan
  • Re: innodb foreign keys problemMichael T. Babcock16 Jan