RE: Foreign key integrity pb ?

2002-06-12 Thread Christophe BRAM
-Message d'origine- De : Tonu Samuel [mailto:[EMAIL PROTECTED]] Envoye : mercredi 12 juin 2002 10:51 A : Christophe BRAM Cc : [EMAIL PROTECTED] Objet : Re: Foreign key integrity pb ? On Wed, 12 Jun 2002, Christophe BRAM wrote: > I'm using MySQL Max 4.0.1 > >

Re: Foreign key integrity pb ?

2002-06-12 Thread Tonu Samuel
On Wed, 12 Jun 2002, Christophe BRAM wrote: > I'm using MySQL Max 4.0.1 > > > CREATE TABLE TableTwo > ( > Id int NOT NULL auto_increment, > FK_TableOne int NOT NULL REFERENCES TableOne(Id), > > PRIMARY KEY (Id) > ) TYPE=InnoDB; > > > --> How can this

Foreign key integrity pb ?

2002-06-12 Thread Christophe BRAM
I'm using MySQL Max 4.0.1 CREATE TABLE TableTwo ( Id int NOT NULL auto_increment, FK_TableOne int NOT NULL REFERENCES TableOne(Id), PRIMARY KEY (Id) ) TYPE=InnoDB; --> How can this work without having beforehand created the table "TableOne" ???