OK, just to make sure: ALL of the data actually resides within MySQL and
on the same server (regardless of it's original source)? That is good as
MySQL does not permit retrieving data from other servers in a query (yet).
So you have a table for the primary Model information, a second table for
the
"mel list_php" <[EMAIL PROTECTED]> wrote on 04/13/2005 11:07:44 AM:
>
>
> >
> >When you mention external databses, I got curious. Do you mean
"external"
> >as in "not on that MySQL server"? Or, do you mean "external" as in
"same
> >server, different database"?
> >
> >If you are designing your
When you mention external databses, I got curious. Do you mean "external"
as in "not on that MySQL server"? Or, do you mean "external" as in "same
server, different database"?
If you are designing your site correctly, the user should know nothing
about your data storage. That means that the "user"
> wants to look, so the search will be only a query to the dedicated table
> (database2 for ex if the user wants to retrieve articles)
>
> Do you think this kind of schema will be ok for the display of
information?
>
> Thank you very much for your time,
> Melanie
>
>
will be ok for the display of information?
Thank you very much for your time,
Melanie
From: "Gordon" <[EMAIL PROTECTED]>
To: "'mel list_php'" <[EMAIL PROTECTED]>,
Subject: RE: design: table depending on a column
Date: Tue, 12 Apr 2005 10:32:17 -0500
As
END AS FIELD2
FROM elements
LEFT JOIN articles
USING (annotationID)
LEFT JOIN names
USING (annotationID)
-Original Message-
From: mel list_php [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 12, 2005 8:59 AM
To: mysql@lists.mysql.com
Subject: design: table de
Hi list,
I have a design problem, I'd like to know if there is a nice way to solve
it
I have elements that can be annotated, an annotation is basic info and a
link on an other database.
For example: my element id 3, called testElement, is annotated.
the annotation depends on the foreign data