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
Hi all, having a spot of bother with a 'keywords' table.
I have a table of articles with an article_id and a table
of categories with a category_id, all is well.
These are linked via a article_link table so that an article
can be a member of multiple categories.
I then have a table of 'keywords' t
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
Greetings MySQL folk,
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.
If someone coul
TECTED]
Subject: Severe performace problem linking tables with mysql
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table
type)
I have discovered a performace issue when joining several tables
together.
The performance is extremely poor when performing select queries using
the
W
22.61 sec)
From: Benjamin Pflugmann <[EMAIL PROTECTED]>
To: Joseph Dietz <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Severe performace problem linking tables with mysql
Date: Wed, 18 Dec 2002 22:22:00 +0100
Hi.
On Wed 2002-12-18 at 18:40:04 +, [EMAIL PROTECTED] wr
Hi.
On Wed 2002-12-18 at 18:40:04 +, [EMAIL PROTECTED] wrote:
>
> PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type)
>
> I have discovered a performace issue when joining several tables together.
> The performance is extremely poor when performing select queries us
Joseph Dietz wrote:
MediasMediaAuthorsAuthors
pk_media_id fk_media_id, fk_author_id pk_author_id
In your table definition, is there an index on each of your keys shown
above? What kind of performance 'degredation'? How many values are you
chec
change to make it quicker.
-Original Message-
From: Joseph Dietz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 10:40 AM
To: [EMAIL PROTECTED]
Subject: Severe performace problem linking tables with
mysql
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type)
I have discovered a performace issue when joining several tables together.
The performance is extremely poor when performing select queries using the
WHERE clause and joining the tables with the pk_media_id = fk_media_
Hello i am kinda new to this list, and to mysql...
I am trying to link 2 tables, but there seems to be an catch i havent
for seen...
i made this table first like this:
create table kunder(KundeID int NOT NULL PRIMARY KEY auto_increment,
Fornavn varchar(25) NOT NULL,
Etternavn varchar(25) NOT NU
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.
---
D]
Subject: Linking tables using INNER JOIN
I am trying to do an inner join between three tables. Here is what I have
tried:
select * from MapConfig LEFT JOIN ConfigString USING (id) LEFT JOIN
ConfigInt
USING (id) WHERE MapConfig.layername = "Roads";
What I am trying to do is to pul
I am trying to do an inner join between three tables. Here is what I have
tried:
select * from MapConfig LEFT JOIN ConfigString USING (id) LEFT JOIN ConfigInt
USING (id) WHERE MapConfig.layername = "Roads";
What I am trying to do is to pull back all rows from MapConfig associated
with matchi
15 matches
Mail list logo