Re: Tables relationships

[Stefan Hinz]

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 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
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



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Tables relationships

[Mani Murugesan]

- 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
I am a developer and am involved in MySQL for the past one year, and have
installed it in around twenty different places with my front end app using
MySQL. My main need is RI.

Mani. M





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Tables relationships

[Christopher R. Jones]

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 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 and if Yes then - how it's could be realised

Help me please!

Andis.

P.S. Sorry about my English.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Tables relationships

[Michael T. Babcock]

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, 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.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php