Marc Slemko wrote:
On Thu, 26 Feb 2004, Keith Thompson wrote:
Given these two tables:
create table t1 (
id int unsigned auto_increment,
a int,
... [other fields]
primary key (id),
index aid (a,id)
) type=innodb;
create table t2 (
id int unsigned,
Given these two tables:
create table t1 (
id int unsigned auto_increment,
a int,
... [other fields]
primary key (id),
index aid (a,id)
) type=innodb;
create table t2 (
id int unsigned,
b int,
... [other fields]
index id (i
On Thu, 26 Feb 2004, Keith Thompson wrote:
> Given these two tables:
>
> create table t1 (
>id int unsigned auto_increment,
>a int,
>... [other fields]
>primary key (id),
>index aid (a,id)
> ) type=innodb;
>
> create table t2 (
>id int un
