Hello.
On my mysql-5.0.6 instance foreign key constraint from your example
works. What output does the following statement produce:
show variables like 'have_innodb';
"Jan Bartholdy" <[EMAIL PROTECTED]> wrote:
> Dear All, I have two tables entity1 and entity2; the second one should
>
Dear All, I have two tables entity1 and entity2; the second one should
contain only data with the same "PLZ" as listed in table "entity1".
Unfortunately, I am able to insert in table entity2 data in the field "PLZ",
different from those in the field PLZ in the table "entity1".
What is going wrong
