10/28/03 6:50:26 AM, Juliana Gubert Ehrensperger <juliana@stripped> 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"?
> Excuse me for asking a so simple question,
If you are trying to determine whether MySQL is a relational database,
the answer is yes.
If you are trying to determine whether MySQL supports foreign keys, the
answer is yes: Use table type InnoDB to get enforcement of foreign key
constraints in MySQL.
If you are trying to determine whether MySQL has a c api equivalent
to Oracle's OCI (sometimes called relational functions), the answer
is yes. See the manual (http://www.mysql.com/doc/en/index.html).
If you need particular relational functions found in some other
database's interface, you may want to check the relevant parts of
MySQL's documentation. MySQL is not the same as Oracle -- it is
its own full-featured, powerful relational database system.