Hi folks,
Can someone please point me in the right direction to let me know how to
define a relationship between tables in MySQL eg one-to-many. I haven't
come across it in the manual yet, but am sure it must be there somewhere.
Many thanks in advance,
Chris Malloch
Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: Chris Malloch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 10:54 AM
Subject: Tables relationships
Hi folks,
Can someone please point me in the right direction to let me know how
- 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.
ps
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: 1)cascade update related fields and 2)cascade delete related
records. Is MySQL realize such things
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
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,