Re: InnoDB interaction between secondary and primary keys.

2013-02-01 Thread Jeremy Chase
; > -Original Message- > > From: Rick James > > Sent: Wednesday, January 30, 2013 1:08 PM > > To: 'Jeremy Chase'; mysql@lists.mysql.com > > Subject: RE: InnoDB interaction between secondary and primary keys. > > > > secondarykey and r

RE: InnoDB interaction between secondary and primary keys.

2013-01-30 Thread Rick James
ql@lists.mysql.com > Subject: RE: InnoDB interaction between secondary and primary keys. > > secondarykey and redundantkey are redundant with each other -- in all > versions of InnoDB. > > One "expert" said that redundant key would have two copies of `1`,`2`. > I think h

RE: InnoDB interaction between secondary and primary keys.

2013-01-30 Thread Rick James
.com > Subject: InnoDB interaction between secondary and primary keys. > > Hello, > > I've been working with a secondary index and would like some > clarification about how the primary columns are included. So, in the > following example, is the secondaryKey effective