NOT NULL auto_increment,
: (other 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,
&
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 a
