Hi
thanks for your help and your answers, it works now.
foreign key (ownerdomain) references domains(domain) on delete cascade
^^^^^^^^^^
^^^^ was missing.
Philipp
> -----Original Message-----
> From: Philipp Snizek [mailto:[EMAIL PROTECTED]
> Sent: Mittwoch, 23. Februar 2005 11:22
> To: mysql@lists.mysql.com
> Subject: RE: referencial integrity problem
>
> Hi
>
> > Hello.
> >
> > What output does the following statement produce:
> >
> > show variables like 'have_innodb';
>
> mysql> show variables like 'have_innodb';
> +---------------+-------+
> | Variable_name | Value |
> +---------------+-------+
> | have_innodb | YES |
> +---------------+-------+
> 1 row in set (0.00 sec)
>
>
> Philipp
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
