Kevin,
To link articles & keywords wouldn't you want a table like this?
CREATE table articles_keywords(
AK_id int auto_increment PRIMARY KEY,
AK_article_id int NOT NULL,
AK_keyword_id int NOT NULL
);
I don't understand why you want the sort of 'dynamic table' you describe.
PB
-
Kevin
Chris Blake wrote:
New to MySL, please bear with me..
I have created two tables
Clients and Jobs
One Client has many jobs.how do I create a relation between the two
tables ?
I have searched the manual using terms like "relations" - "create
relations" etc etc to no avail.
Look up "join". T
* Chris Blake
> I have created two tables
> Clients and Jobs
>
> One Client has many jobs.how do I create a relation between the two
> tables ?
Simply by including a column in the jobs table 'pointing' to the client
table. Say, for instance, that the Client table have a unique primary key
called C
On Thursday 21 February 2002 3:29 pm, Rick Emery wrote:
> try:
> select * from MapConfig mc LEFT JOIN ConfigString USING (id)
> LEFT JOIN ConfigInt cf on mc.id=cf.id WHERE MapConfig.layername = "Roads";
Heh. It's been too long since I worked with SQL.
Thanks, that worked perfectly.
---
try:
select * from MapConfig mc LEFT JOIN ConfigString USING (id)
LEFT JOIN ConfigInt cf on mc.id=cf.id WHERE MapConfig.layername = "Roads";
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 4:24 PM
To: [EMAIL PROTECTED]
Subject:
