Christos,
Monday, October 21, 2002, 5:46:07 AM, you wrote:
CS> Hello I am a brand new user of MySql, and have some questions about
CS> using InnoDB tables.
CS> I noticed in the manual that you can only specify
CS> - ON DELETE SET NULL
CS> Or
CS> - ON DELETE CASCADE
CS> What is the default b
Hello I am a brand new user of MySql, and have some questions about
using InnoDB tables.
I noticed in the manual that you can only specify
- ON DELETE SET NULL
Or
- ON DELETE CASCADE
What is the default behaviour if nothing is specified?
Also, does anyone know if there are any plans to s
Hello I am a brand new user of MySql, and have some questions about
using InnoDB tables.
I noticed in the manual that you can only specify
- ON DELETE SET NULL
Or
- ON DELETE CASCADE
What is the default behaviour if nothing is specified?
Also, does anyone know if there are any plans to su
Martin,
-Original Message-
From: "Martin Bratbo" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Date: Saturday, February 16, 2002 4:46 PM
Subject: Re: Re: Foreign keys in InnoDB tables
>Heikki
>here is the statements that i cant get to work:
>first I
Heikki
here is the statements that i cant get to work:
first I create one innoDB table: fk1
create table fk1( noegle integer primary key, tekst varchar(20))type=InnoDB;
then I create a second InnoDB table: fk2which references the first:
create table fk2( prim integer primary key, frem intege
According to the manual it should in fact be possible to enforce foreign =
key constraint in MySql if both the referreing and referred tables are =
of type InnoDB. But I haven't been able to, make the foreign keys work, =
they did'nt blok any insertions.
Are foreign keys still only for compabilit
Martin,
there is a bug in 4.0.1 which can make a foreign key definition to fail in
an assertion failure in dict0crea.c, if you have set default-character-set
to something else than latin1 in my.cnf.
Harald Fuchs reported the bug on this mailing list a couple of days ago, and
the bug is now fixed
According to the manual it should in fact be possible to enforce foreign key
constraint in MySql if both the referreing and referred tables are of type InnoDB. But
I haven't been able to, make the foreign keys work, they did'nt blok any insertions.
Are foreign keys still only for compability, o
