Dear Chris,
look here: http://www.mysql.com/doc/J/O/JOIN.html
It's one of the JOINs (INNER JOIN or LEFT JOIN) you are looking for.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berl
- Original Message -
> No, MySQL does not help in enforcing referential integrity. You need to
>do that with your application. In some people's opinion (not mine), it is
>one of the major drawbacks to using MySQL.
I agree. MySQL needs to have RI as its first priority on its TODO list.
Has anyone ever bothered to make a front-end API to MySQL that does maintain
referential integrity and/or allow function calls on events? It might make
an interesting library to write for RDBMS migrators ...
- Original Message -
From: "Christopher R. Jones" <[EMAIL PROTECTED]>
> No, My
"Andis Grasis" <[EMAIL PROTECTED]> wrote:
> Is it's possible to make some kind of relationships between tables
> as it's realised in MsAccess. In MsAccess databases it's called
> "Enforce referential integerity" and it's have some subchoises:
MySQL does not have referential integrity. Though it'
No, MySQL does not help in enforcing referential integrity. You need to do
that with your application. In some people's opinion (not mine), it is one
of the major drawbacks to using MySQL.
>Is it's possible to make some kind of relationships between tables as it's
>realised in MsAccess. In