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.
When I
on delete cascade
) type=3Dinnodb;
Philipp=20
=20
Rhino
=20
- Original Message -
From: Philipp Snizek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Mysql List (E-mail)=20
mysql@lists.mysql.com
Sent: Tuesday, February 22, 2005 7:49 AM
Subject: RE: referencial integrity
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
: 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
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
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
, 2005 7:49 AM
Subject: RE: referencial integrity problem
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