> An: [EMAIL PROTECTED]
> Betreff: Re: Foreign Keys with MySQL 3.23.49 and 3.23.50
>
> In article <[EMAIL PROTECTED]>,
> "Jostkleigrewe, Heiner" <[EMAIL PROTECTED]> writes:
>
> >> sql,query
> >>
> >> Hello,
> >>
> >
This example is in InnoDB though, which should support foreign key
constraints.
Chris Book
>>In other words data integrity between two tables is not ensured by MySQL.
Your application code must solve this.
-
Before posting, p
Hi
Nothing is wrong! The behaviour of your example is correct, because
MySQL does not support the concept of foreign keys. See section 1.4.4.5
of the MySQL manual. In other words data integrity between two tables is
not ensured by MySQL. Your application code must solve this.
Regards
Rene Mo
> sql,query
>
> Hello,
>
> i've tried the foreign key-example out of the documentation(3.5.6 Using
> Foreign Keys) on W2K (3.23.49 + 3.23.50) and LINUX (3.23.49). The tables
> persons and shirts are created as innodb-tables.
>
> I could insert a shirt for a non-existing person. Also i could de
