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 redundantkey are redundant with each other -- in all versions of InnoDB. One

RE: InnoDB interaction between secondary and primary keys.

2013-01-30 Thread Rick James
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 effectively the same as redundantKey? CREATE TABLE `example` ( `1` int

RE: InnoDB interaction between secondary and primary keys.

2013-01-30 Thread Rick James
AM To: mysql@lists.mysql.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 effectively