Hi Richard,
Can you make a relationship between COMPOSITIONS and INSTALATIONS? If so,
then you make a relationship between COMPSOTIONS_ONSTALATIONS and
PERFORMANCES.
Laercio.
-Original Message-
From: Richard Lewis [mailto:[EMAIL PROTECTED] On Behalf Of Richard Lewis
Sent: terça-feira,
What do you mean by relations? Like table relations such as with FK in
innodb?
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Robert Morgan [mailto:[EMAIL PROTECTED]
-->Sent: Thursday
* Robert Morgan
> Hi, is there a way of showing relationships in mysql?
>
> such as. mysql> SHOW relationships
No. The relationships are dynamic, defined by join statements on the fly.
You can however show any defined foreign key constraints using "SHOW CREATE
TABLE tablename".
--
Roger
--
MyS
* Paulo
> Hi, sorry for my english, but, how can I do relationships between
> tables? Is possible?
This is done using different types of JOIN:
http://www.mysql.com/doc/en/JOIN.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
el [DATE], [NAME] en [ADDRESS] escribió:
Thank you for your help and for the lesson.
Eli
> I would just add a few words to Nils' excellent reply:
>
> In the most general sense, a foreign key is just a primary
> key value that occurs outside of its native table (i.e. in
> a "foreign" table, get
You need to have some sort of unique identifier, like a primary key.
And all the tables should agree upon that
Defryn, Guy wrote:
DG: Date: Tue, 18 Dec 2001 10:37:41 +1300
DG: From: "Defryn, Guy" <[EMAIL PROTECTED]>
DG: To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
DG: Subject:
e keyboard over simplifies the process and itself imposes data
integrity questions.
Pat...
.
- Original Message -
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 14, 2001 9:28 PM
Subject: Re: Relati
[EMAIL PROTECTED] wrote:
> Hello all,
>
> Without explicitly creating foreign keys, what is the most common method to
> create a truly relational database that enforces referential integrity?
>
> Any responses to this question are greatly appreciated!
>
> Sincerely,
>
> N. Silverwise
>
Referenti
If you are really after referential integrity then perhaps you should
consider another database or you could always modify the code.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 8:32
Subject: Relationships???
> Hello all,
>
> Without
