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'
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 could
* 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
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. The
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 =
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
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
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 using
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] wrote:
PLATFORM: 3.23.52
: 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
WHERE clause
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
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
: 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 pull back all rows from
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.
15 matches
Mail list logo