Re: Re: Foreign keys in InnoDB tables

2002-02-16 Thread Heikki Tuuri
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

Re: Re: Foreign keys in InnoDB tables

2002-02-16 Thread Martin Bratbo
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