From: Rick James
Date: November 14 2012 3:49pm
Subject: RE: Dynamic crosstab got me lost.
List-Archive: http://lists.mysql.com/mysql/228622
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB14911AA7E4@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

V2hpbGUgaXQgaXMgcG9zc2libGUgdG8gcGl2b3QgYSB0YWJsZSBsaWtlIHRoYXQsIHRoZSBjb2Rl
IGlzIHVnbHksIGFuZCBkb2VzIG5vdCB3b3JrIHdlbGwgaWYgeW91IG5lZWQgYSB2YXJpYWJsZSBu
dW1iZXIgb2YgY29sdW1ucy4NCg0KU1FMIGNhbiBkbyB0aGUgSk9JTiB0byBnZXQgYSBzaW5nbGUg
cmVzdWx0c2V0IGZvciB0aGUgaW5mb3JtYXRpb24sIGJ1dCB0aGUgbGF5b3V0IGlzIGJlc3QgZG9u
ZSBpbiBhIGFwcGxpY2F0aW9uIGxhbmd1YWdlLCBzdWNoIGFzIFBIUC4NCg0KPiAtLS0tLU9yaWdp
bmFsIE1lc3NhZ2UtLS0tLQ0KPiBGcm9tOiBNb2dlbnMgTWVsYW5kZXIgW21haWx0bzptb2dlbnNA
ZnVtbGVyc29mdC5ka10NCj4gU2VudDogV2VkbmVzZGF5LCBOb3ZlbWJlciAxNCwgMjAxMiAxMjoy
MyBBTQ0KPiBUbzogbXlzcWxAbGlzdHMubXlzcWwuY29tDQo+IFN1YmplY3Q6IER5bmFtaWMgY3Jv
c3N0YWIgZ290IG1lIGxvc3QuDQo+IA0KPiBHdXJ1J3MNCj4gDQo+IEkndmUgYmVlbiB0YXNrZWQg
d2l0aCBjcmVhdGluZyBhIHJlcG9ydCB3aXRoIGluZm9ybWF0aW9uIGFib3V0IHdoaWNoIGltYWdl
cw0KPiBhcmUgcmVsYXRlZCB0byBlYWNoIGFjdGl2ZSBhcnRpY2xlLiBUaGUgaW1hZ2VzIGFyZSBk
ZXNjcmlwdGl2ZSBpY29ucw0KPiB2aXN1YWxpemluZyBkaWZmZXJlbnQgcHJvcGVydGllcy4NCj4g
DQo+IEFydGljbGVzIGNhbiBiZSBhY3RpdmUgJ29uJyBvciBub3QgJycsIGFuZCBvbmx5IGFjdGl2
ZSBpcyB0byBiZSBpbmNsdWRlZCBpbg0KPiB0aGUgcmVzdWx0Lg0KPiANCj4gVGhlIG51bWJlciBv
ZiBhdmFpbGFibGUgaWNvbnMgY2hhbmdlcyBjb25zdGFudGx5LCBhbmQgYXJlIHRvbyBtYW55LCB0
byB1c2UNCj4gYW55dGhpbmcgc3RhdGljLg0KPiANCj4gV2hhdCBJIGdvdCBpczoNCj4gDQo+IFRh
YmxlOiBtYWluDQo+IC0tLS0tLS0tLS0tLS0tLS0tDQo+IGNvZGUgKGludCkNCj4gYWN0aXZlIChv
bi9vZmYpDQo+IC0tLS0tLS0tLS0tLS0tLS0tDQo+IA0KPiBUYWJsZTogaWNvbg0KPiAtLS0tLS0t
LS0tLS0tLS0tLQ0KPiBpZCAoaW50KQ0KPiBmaWxlbmFtZSAoY2hhcikNCj4gLS0tLS0tLS0tLS0t
LS0tLS0NCj4gDQo+IFRhYmxlOiBpY29ucmVsDQo+IC0tLS0tLS0tLS0tLS0tLS0tDQo+IGNvZGUg
KGludCkNCj4gaWNvbiAoaW50KQ0KPiAtLS0tLS0tLS0tLS0tLS0tLQ0KPiANCj4gV2hhdCBJIG5l
ZWQgaXMgc29tZXRoaW5nIGxpa2U6DQo+IA0KPiBjb2RlCWZpbGVuYW1lMQlmaWxlbmFtZTIJZmls
ZW5hbWUzCWZpbGVuYW1lTg0KPiAxMTExCW9uCQlvZmYJCW9mZgkJb24NCj4gDQo+IEhvcGVmdWxs
eSBzb21lYm9keSBvdXQgdGhlcmUgZ290IG1vcmUgb2YgYSBjbHVlIHRoYW4gSSBkby4NCj4gDQo+
IEFueSBpZGVhcywgYW55Ym9keT8NCj4gDQo+IC0tDQo+IE1vZ2VucyBNZWxhbmRlcg0KPiArNjYg
ODcwMSAzMzIyNA0KPiANCj4gLS0NCj4gVGhpcyBtZXNzYWdlIGhhcyBiZWVuIHNjYW5uZWQgZm9y
IHZpcnVzZXMgYW5kDQo+IGRhbmdlcm91cyBjb250ZW50IGJ5IE1haWxTY2FubmVyLCBhbmQgaXMN
Cj4gYmVsaWV2ZWQgdG8gYmUgY2xlYW4uDQo+IA0KPiANCj4gLS0NCj4gTXlTUUwgR2VuZXJhbCBN
YWlsaW5nIExpc3QNCj4gRm9yIGxpc3QgYXJjaGl2ZXM6IGh0dHA6Ly9saXN0cy5teXNxbC5jb20v
bXlzcWwNCj4gVG8gdW5zdWJzY3JpYmU6ICAgIGh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlzcWwN
Cg0K