Re: Foreigner keys in MySQL?

2003-10-28 Thread [EMAIL PROTECTED]
Martijn Tonies wrote: Nevertheless, I received the information that MySQL don't support relacional functions between tables of the same database. I'm not sure about this, and I'd like to confirm this information. Does MySQL allow relacionl functions between tables recognizing "foreign keys"? Ex

RE: Foreigner keys in MySQL?

2003-10-28 Thread John Griffin
s you will find that MySQL fits this definition nicely. John Griffin -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 11:11 AM To: [EMAIL PROTECTED] Subject: Re: Foreigner keys in MySQL? > >Nevertheless, I received the inform

Re: Foreigner keys in MySQL?

2003-10-28 Thread Martijn Tonies
> >Nevertheless, I received the information that MySQL don't support > >relacional functions between tables of the same database. I'm not sure > >about this, and I'd like to confirm this information. Does MySQL allow > >relacionl functions between tables recognizing "foreign keys"? > >Excu

Re: Foreigner keys in MySQL?

2003-10-28 Thread bluejack
10/28/03 6:50:26 AM, Juliana Gubert Ehrensperger <[EMAIL PROTECTED]> wrote: >Nevertheless, I received the information that MySQL don't support >relacional functions between tables of the same database. I'm not sure >about this, and I'd like to confirm this information. Does MySQL allow >relaci

Re: Foreigner keys in MySQL?

2003-10-28 Thread Peter Brawley
Yes it does. - Original Message - From: Juliana Gubert Ehrensperger To: SQL List Sent: Tuesday, October 28, 2003 8:50 AM Subject: Foreigner keys in MySQL? Hello all, I'm joined to a research project and by now we need to specify a software to build a database. Al

RE: Foreigner keys in MySQL?

2003-10-28 Thread Michael McTernan
Hi, If you mean foreign key constraints, it's available with InnoDb tables under MySQL, as are atomic transactions (commit and rollback). I'm using this with MySQL4.0 and it works a treat :) Thanks, Mike > -Original Message- > From: Juliana Gubert Ehrensperger [mailto:[EMAIL PROTECTED]