stuff)
PRIMARY KEY (media_id)
) TYPE=MyISAM PACK_KEYS=1;
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 17, 2002 11:13 AM
Subject: Re: slow query in MySQL 4
Tac,
Saturday, August 17, 2002, 12:57:24 AM, you wrote:
T A simple query
Tac,
Saturday, August 17, 2002, 12:57:24 AM, you wrote:
T A simple query in MySQL 4 that gets a count from 3 inner joined tables:
T select count(*) as C from quotes q inner join articles a using (article_id)
T inner join media m using (media_id)
T article_id and media_id are int(11), and are
A simple query in MySQL 4 that gets a count from 3 inner joined tables:
select count(*) as C from quotes q inner join articles a using (article_id)
inner join media m using (media_id)
article_id and media_id are int(11), and are the primary keys for their
respective tables. When used as