TECTED]
> 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 '
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.
;>=20
>> ----- Original Message -
>> From: "Philipp Snizek" <[EMAIL PROTECTED]>
>> To: <[EMAIL PROTECTED]>; "Mysql List (E-mail)"=20
>>
>> Sent: Tuesday, February 22, 2005 7:49 AM
>> Subject: RE: referencial integr
Hello.
Use InnoDB tables instead of MyISAM. See:
http://dev.mysql.com/doc/mysql/en/ansi-diff-foreign-keys.html
"Philipp Snizek" <[EMAIL PROTECTED]> wrote:
> Hi
>
> I run a Postfix MTA attached to a mysql DB with various domains on it.
> A domain consists of email addresses.
> W
: <[EMAIL PROTECTED]>; "Mysql List (E-mail)"
>
> Sent: Tuesday, February 22, 2005 7:49 AM
> Subject: RE: referencial integrity problem
>
>
>
> > Foreign keys are only supported within InnoDB tables (on both
> sides)..
>
> so using a table 'u
> Foreign keys are only supported within InnoDB tables (on both
sides)..
so using a table 'users' like
create table users (
email varchar (80) primary key unique not null,
belongs_to integer not null references domains on delete cascade
);
without foreign keys could help?
I couldn't mak
Foreign keys are only supported within InnoDB tables (on both sides)..
Mark
Mark Leith
Cool-Tools
http://www.cool-tools.co.uk
-Original Message-
From: Philipp Snizek [mailto:[EMAIL PROTECTED]
Sent: 22 February 2005 10:30
To: Mysql List (E-mail)
Subject: referencial integrity problem