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 -- #
&g
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 PROTE
> 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'
--- Okan CIMEN <[EMAIL PROTECTED]> ha scritto: >
There are no other way
> you have to create the index first
>
> - Original Message -
> From: "Natale Babbo" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, Janu
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
# - 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