Re: foreign keys.

2003-12-17 Thread Mofeed Shahin
hehehe, Yeah figures that it was something stupid I did!!! Thanks for that. Mof. On Thu, 18 Dec 2003 09:30 am, Heikki Tuuri wrote: > Mofeed, > > - Original Message - > From: "Mofeed Shahin" <[EMAIL PROTECTED]> > To: "Heikki Tuuri" <[E

Re: foreign keys.

2003-12-17 Thread Mofeed Shahin
On Thu, 18 Dec 2003 09:05 am, Heikki Tuuri wrote: > Mofeed, > > - Original Message - > From: "Mofeed Shahin" <[EMAIL PROTECTED]> > To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, December 18, 2003 12:2

Re: foreign keys.

2003-12-17 Thread Mofeed Shahin
pport from https://order.mysql.com/ > > - Original Message - > From: "Mofeed Shahin" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Wednesday, December 17, 2003 1:19 AM > Subject: Re: foreign keys. > > > mysql> CREATE TABLE foo (

Re: foreign keys.

2003-12-17 Thread Mofeed Shahin
On Wed, 17 Dec 2003 07:55 pm, Victoria Reznichenko wrote: > Mofeed Shahin <[EMAIL PROTECTED]> wrote: > > mysql> CREATE TABLE foo ( > >-> ID INT PRIMARY KEY, > >-> note VARCHAR(50), > >-> First_Name VARCHAR

Re: foreign keys.

2003-12-16 Thread Mofeed Shahin
16 Dec 2003 07:54 pm, Victoria Reznichenko wrote: > Mofeed Shahin <[EMAIL PROTECTED]> wrote: > > Still doesn't work But thanks for trying. > > Worked fine for me: > > mysql> CREATE TABLE Blah ( > -> ID INT PRIMARY KEY, > ->

Re: foreign keys.

2003-12-15 Thread Mofeed Shahin
t work,its not me > > > > > FOREIGN KEY (FOO_ID) REFERENCES foo(ID), > > > FOREIGN KEY (Fname, Lname) REFERENCES Blah (Fname, Lname) > > > ) TYPE=INNODB; > > > > Mofeed Shahin wrote: > >> On Mon, 15 Dec 2003 09:22 pm, Victoria Reznichen

Re: foreign keys.

2003-12-15 Thread Mofeed Shahin
ame VARCHAR(50), > >Lname VARCHAR(50), > >FOO_ID INT, > >INDEX(FOO_ID), > >KEY(Fname,Lname), #here this one--if it does not work,its not me > > >FOREIGN KEY (FOO_ID) REFERENCES foo(ID), > >FOREIGN KEY (Fname, Lname) REFERENCE

Re: foreign keys.

2003-12-15 Thread Mofeed Shahin
On Mon, 15 Dec 2003 09:22 pm, Victoria Reznichenko wrote: > Mofeed Shahin <[EMAIL PROTECTED]> wrote: > > On Mon, 15 Dec 2003 12:42 pm, Paul DuBois wrote: > >> At 11:09 +1030 12/15/03, Mofeed Shahin wrote: > >> >I'm trying to create a bunch of tables in M

Re: foreign keys.

2003-12-14 Thread Mofeed Shahin
On Mon, 15 Dec 2003 12:42 pm, Paul DuBois wrote: > At 11:09 +1030 12/15/03, Mofeed Shahin wrote: > >I'm trying to create a bunch of tables in MySQL. I'm having problems > > creating the following table : > > > >CREATE TABLE foo( > > ID INT PRIMARY KE

foreign keys.

2003-12-14 Thread Mofeed Shahin
I'm trying to create a bunch of tables in MySQL. I'm having problems creating the following table : CREATE TABLE foo( ID INT PRIMARY KEY, note VARCHAR(50), FOO_ID INT, FOREIGN KEY (FOO_ID) REFERENCES foo(ID) ) TYPE=INNODB; The error I get is the following : ERR