With respect, I must disagree with your assertion that MySQL is not a relational database.
I did a Google on "definition of a relational database" and found a good definition at
http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci212885,00.html. If you read
this you will find that MySQL fits this definition nicely.
From: Martijn Tonies [mailto:m.tonies@stripped]
Sent: Tuesday, October 28, 2003 11:11 AM
Subject: Re: Foreigner keys in MySQL?
> > 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"?
> > Excuse me for asking a so simple question,
> If you are trying to determine whether MySQL is a relational database,
> the answer is yes.
Ehm... the answer is "no".
It's getting better, that's for sure.
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1