Re: Foreign Key definition

2003-07-22 Thread Egor Egorov
Michael Satterwhite <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Monday 21 July 2003 04:14, Egor Egorov wrote: >> Michael Satterwhite <[EMAIL PROTECTED]> wrote: >> > I'm trying to add a foreign key to a table. All tables are INNODB. Table >> > a has following

Re: Foreign Key definition

2003-07-21 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 21 July 2003 04:14, Egor Egorov wrote: > Michael Satterwhite <[EMAIL PROTECTED]> wrote: > > I'm trying to add a foreign key to a table. All tables are INNODB. Table > > a has following partial Definition: > > > > TableA > > ( Fld1 int Primary

Re: Foreign Key definition

2003-07-21 Thread Egor Egorov
Michael Satterwhite <[EMAIL PROTECTED]> wrote: > > I'm trying to add a foreign key to a table. All tables are INNODB. Table a has > following partial Definition: > > TableA > ( Fld1 int Primary Key,... > ) > > TableB > (Fld2 int Primary Key, > Fld1 int not null, ... > ) > > I use the following

Foreign Key definition

2003-07-19 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm trying to add a foreign key to a table. All tables are INNODB. Table a has following partial Definition: TableA ( Fld1 int Primary Key,... ) TableB (Fld2 int Primary Key, Fld1 int not null, ... ) I use the following Statement: Alter Ta