Natale,
- Original Message -
From: "Natale Babbo" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, January 15, 2003 9:33 AM
Subject: innofb foreign keys problem
> # - 3rd post - #
> # - PLEASE HELP -- #
>
> hi to all,
>
> is it s
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
> 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?
I agree with you 100%.
A foreign key,as
: 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'
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
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
