macrosoft misleads thousands of people by the way
they designed access. in your case, they've
confused relations with referential integrity.
we cringe when that question hits this list, as
it does periodically.
relational databases don't have hard coded
relations. NEVER. furthermore, re
John Meyer wrote:
AFAIK, MySQL doesn't have any sort of referential integrity checks with
fields. conceptually, you can do it, and write your program to force it,
but the database itself doesn't have it.
Or you can use REFERENCES with InnoDB tables;
http://www.mysql.com/doc/en ... search fo
FROM table1 t1 LEFT JOIN table2 t2 ON t1.field=t2.field
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com]
Sent: Wednesday, November 13, 2002 8:14 AM
To: MySQL Mailinglist
Subject: RE: How to link tables in MySQL
AFAIK, MySQL doesn't have any sort of refere
Hannes Niedner [mailto:hannes.niedner@;gmx.net]
Sent: Tuesday, November 12, 2002 1:55 PM
To: MySQL Mailinglist
Subject: Re: How to link tables in MySQL
On 11/12/02 12:41 PM, "tmb" <[EMAIL PROTECTED]> wrote:
> 2 - In MS Access you have to graphically connect the
> table id fields
You can still use Access to build your queries then click the SQL button
and you'll have the the code for the command line. Access SQL is a
little different but you should still be able to get an idea on how to
do it.
- Ed
>>> tmb <[EMAIL PROTECTED]> 11/12/02 12:41:49 PM >>>
1 - any way to search
On 11/12/02 12:41 PM, "tmb" <[EMAIL PROTECTED]> wrote:
> 2 - In MS Access you have to graphically connect the
> table id fields to tell Access how the tables relate.
>
> How do you do this In MySQL... from the command line
> I'm sure... just a code snippit or reference to one
> would be nice...