Re: Foreign Key in Innodb and Index Usages

2003-06-07 Thread Titu Kim
Thank you Bruce and Paul, Your explanation help clear a lot of doubts. So If i create another two tables, let say INVOICE2 and LINEITEM2 with the same construct, when i specify the index for the foreign key and referenced key, MYSQL will create a separate index for these two tables even i only use

Re: Foreign Key in Innodb and Index Usages

2003-06-07 Thread Paul DuBois
At 11:40 -0700 6/7/03, Titu Kim wrote: Hi, I have search the mailing list about the explanation for foreign key in Innodb. I also search goole groups. I have the following doubts. 1. From the documentation i read about the following. === Both tables

Re: Foreign Key in Innodb and Index Usages

2003-06-07 Thread Bruce Feist
Titu Kim wrote: 1. From the documentation i read about the following. === Both tables have to be InnoDB type and there must be an index where the foreign key and the referenced key are listed as the FIRST columns. ===

Re: Foreign key in INNODB

2003-01-17 Thread Rafal Jank
> >>> > >> > >>equipID is a PRIMARY KEY ;) > >> But you don't have index in which ifName is on the first place - and you yave to have it. > > Well!!! ifname also a Primary key!! > > > >ysql> CREATE TABLE equipment_interfaces ( > >> -> equipID CHAR(20) NOT NULL, > >> ->

Re: Foreign key in INNODB

2003-01-16 Thread vinita Vigine Murugiah
vinita Vigine Murugiah wrote: Egor Egorov wrote: On Thursday 16 January 2003 00:12, vinita Vigine Murugiah wrote: Rafal Jank wrote: On Wed, 15 Jan 2003 11:02:44 +1100 vinita Vigine Murugiah <[EMAIL PROTECTED]> wrote: HI I'm not sure what is wrong with my CREATE TABLE syntax, Please

re: Re: Foreign key in INNODB

2003-01-16 Thread Egor Egorov
On Thursday 16 January 2003 00:12, vinita Vigine Murugiah wrote: > Rafal Jank wrote: > >On Wed, 15 Jan 2003 11:02:44 +1100 > > > >vinita Vigine Murugiah <[EMAIL PROTECTED]> wrote: > >>HI > >>I'm not sure what is wrong with my CREATE TABLE syntax, Please advice > > > >There is no index on ifnam

Re: Foreign key in INNODB

2003-01-15 Thread vinita Vigine Murugiah
Rafal Jank wrote: On Wed, 15 Jan 2003 11:02:44 +1100 vinita Vigine Murugiah <[EMAIL PROTECTED]> wrote: HI I'm not sure what is wrong with my CREATE TABLE syntax, Please advice There is no index on ifname in table equipment_interfaces. Well.. Then how come Foreign key equipID in table

re: Foreign key in INNODB

2003-01-15 Thread Egor Egorov
On Wednesday 15 January 2003 02:02, vinita Vigine Murugiah wrote: > HI > I'm not sure what is wrong with my CREATE TABLE syntax, Please advice [skip] > mysql> CREATE TABLE equipment_interfaces ( > -> equipID CHAR(20) NOT NULL, > -> ifName CHAR(20) NOT NULL, >

Re: Foreign key in INNODB

2003-01-15 Thread Rafal Jank
On Wed, 15 Jan 2003 11:02:44 +1100 vinita Vigine Murugiah <[EMAIL PROTECTED]> wrote: > HI > I'm not sure what is wrong with my CREATE TABLE syntax, Please advice > > There is no index on ifname in table equipment_interfaces. > > mysql> CREATE TABLE equipment ( > -> equipID CH