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
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
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
