RE: [EXTERNAL] Re: select decimal column from mysql
"Fennell, Brian" <[email protected]> Mon, 20 Dec 2021 16:48:47 +0000
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <MN2PR14MB3294CD7E7B28795FA8617CC1A27B9@MN2PR14MB3294.namprd14.prod.outlook.com> |
QmVmb3JlIHNvbWVvbmUgcG9pbnRzIG91dCB0aGF0IG15IGRlc2NyaXB0aW9uIG9mIHBlcmwgdmFy aWFibGVzIGlzIGluY29tcGxldGU6DQoNCkhlcmUgYXJlIHRoZSBleHRyYSBkZXRhaWxzIGZvciB0 aGUgdmVyeSBjdXJpb3VzOg0KDQpodHRwczovL3Blcmxkb2MucGVybC5vcmcvcGVybGd1dHMjRGF0 YXR5cGVzDQoNCmh0dHBzOi8vbWV0YWNwYW4ub3JnL3BvZC9TY2FsYXI6OlV0aWwNCg0KaHR0cHM6 Ly9wZXJsZG9jLnBlcmwub3JnL1NjYWxhcjo6VXRpbCNkdWFsdmFyDQoNCmh0dHBzOi8vcGVybGRv Yy5wZXJsLm9yZy9TY2FsYXI6OlV0aWwjaXNkdWFsDQoNCmh0dHBzOi8vcGVybGRvYy5wZXJsLm9y Zy9TY2FsYXI6OlV0aWwjaXN2c3RyaW5nDQoNCmh0dHBzOi8vcGVybGRvYy5wZXJsLm9yZy9TY2Fs YXI6OlV0aWwjbG9va3NfbGlrZV9udW1iZXINCg0KaHR0cHM6Ly9tZXRhY3Bhbi5vcmcvcmVsZWFz ZS9OV0NMQVJLL3BlcmwtNS44Ljgvdmlldy9wb2QvcGVybGFwaS5wb2QNCg0KaHR0cHM6Ly9tZXRh Y3Bhbi5vcmcvcG9kL1BPU0lYOjoxMDAzOjpNYXRoDQoNCmh0dHBzOi8vd3d3LnBlcmwuY29tL3B1 Yi8yMDEyLzA2L3Blcmx1bmljb29rLWZ1cnRoZXItcmVzb3VyY2VzLmh0bWwvDQoNCmh0dHBzOi8v cGVybGRvYy5wZXJsLm9yZy9wZXJsYXBpDQoNCmh0dHBzOi8vcGVybGRvYy5wZXJsLm9yZy9wZXJs ZW1iZWQNCg0KaHR0cHM6Ly9wZXJsZG9jLnBlcmwub3JnL0RldmVsOjpQZWVrDQoNCmh0dHBzOi8v d3d3Lm5udHAucGVybC5vcmcvZ3JvdXAvcGVybC5wZXJsNS5wb3J0ZXJzLzIwMTUvMTEvbXNnMjMy OTc0Lmh0bWwNCg0KDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IEZlbm5l bGwsIEJyaWFuDQpTZW50OiBNb25kYXksIERlY2VtYmVyIDIwLCAyMDIxIDEwOjE0IEFNDQpUbzog am9obiBtaWt5IDxnYjIzMTNAZ21haWwuY29tPjsgZGJpLXVzZXJzQHBlcmwub3JnDQpTdWJqZWN0 OiBSRTogW0VYVEVSTkFMXSBSZTogc2VsZWN0IGRlY2ltYWwgY29sdW1uIGZyb20gbXlzcWwNCg0K VmFyaWFibGVzIGluIHBlcmwgYXJlIOKAnHVudHlwZWTigJ0gb3IgYmV0dGVyIHlldCDigJxkeW5h bWljYWxseSB0eXBlZOKAnS4NCkV2ZXJ5IHZhcmlhYmxlIGlzIGEgc3RyaW5nIGJ1dCB3aWxsIGJl aGF2ZSBsaWtlIGEgaW50IG9yIGZsb2F0IGluIHRoZSByaWdodCBjb250ZXh0Lg0KQ29udmVyc2lv bnMgZnJvbSBzdHJpbmcgdG8gaW50IHRvIGZsb2F0IGFuZCBiYWNrIHRvIHN0cmluZyBoYXBwZW4g YXV0b21hdGljYWxseSBhbmQgc2lsZW50bHkuDQpUaGlzIG1heSBiZSBzdXJwcmlzaW5nIGFuZCBj b25mdXNpbmcgaWYgeW91IGFyZSBjb21pbmcgZnJvbSBqYXZhLg0KDQpFeGFtcGxlOg0KDQpwZXJs IC1lICckdiA9ICIxMjMiIDsgcHJpbnQgJHYgLiAiXG4iIDsgJHYgKz0gMiA7IHByaW50ICR2IC4g IlxuIjsgJHYgLz0gMi4wIDsgcHJpbnQgJHYgLiAiXG4iOyBwcmludCBsZW5ndGgoJHYpIC4gIlxu IjsgJHYgPSAiKCIgLiAkdiAuICIpIjsgcHJpbnQgJHYgLiAiXG4iJw0KMTIzDQoxMjUNCjYyLjUN CjQNCig2Mi41KQ0KDQoNCg0KRnJvbTogam9obiBtaWt5IDxnYjIzMTNAZ21haWwuY29tPg0KU2Vu dDogTW9uZGF5LCBEZWNlbWJlciAyMCwgMjAyMSAxOjI4IEFNDQpUbzogZGJpLXVzZXJzQHBlcmwu b3JnDQpTdWJqZWN0OiBbRVhURVJOQUxdIFJlOiBzZWxlY3QgZGVjaW1hbCBjb2x1bW4gZnJvbSBt eXNxbA0KDQpzb3JyeSwgcGxlYXNlIGlnbm9yZSB0aGlzIHN0dXBpZCBxdWVzdGlvbiwgMC4wMTUg aXMgPiAwDQoNCk9uIE1vbiwgRGVjIDIwLCAyMDIxIGF0IDI6MTkgUE0gam9obiBtaWt5IDxtYWls dG86Z2IyMzEzQGdtYWlsLmNvbT4gd3JvdGU6DQpobW0uIGl0IGlzIHBlcmwncyAicHJvYmxlbSIs IG5vdCBkYmkuDQoNCk9uIE1vbiwgRGVjIDIwLCAyMDIxIGF0IDE6MjAgUE0gam9obiBtaWt5IDxt YWlsdG86Z2IyMzEzQGdtYWlsLmNvbT4gd3JvdGU6DQpoaSwNCg0KSSBzZWxlY3QgYSBkZWNpbWFs IGNvbHVtbiwgZnJvbSBteXNxbCB3aXRoIGRiaSwgdGhlIHZhbHVlIDAuMDE1IGZvciBleGFtcGxl LCAgbXkgKCR2KSA9ICRkYmgtPnNlbGVjdHJvd19hcnJheSgic2VsZWN0IHByaWNlIGZyb20gdGVz dCBsaW1pdCAxIikgaXQgaXMgZ3JlYXRlciB0aGFuIDAgaW4gcGVybC4NCg0KV2hhdCdzIHRoZSBw cm9wZXIgd2F5IHRvIGdldCBhIGZsb2F0IHZhbHVlID8NCg0KDQoNClRoZSBpbmZvcm1hdGlvbiBj b250YWluZWQgaW4gdGhpcyBlbGVjdHJvbmljIG1haWwgdHJhbnNtaXNzaW9uIGlzIGludGVuZGVk IG9ubHkgZm9yIHRoZSB1c2Ugb2YgdGhlIGluZGl2aWR1YWwgb3IgZW50aXR5IG5hbWVkIGluIHRo aXMgdHJhbnNtaXNzaW9uLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50IG9m IHRoaXMgdHJhbnNtaXNzaW9uLCB5b3UgYXJlIGhlcmVieSBub3RpZmllZCB0aGF0IGFueSBkaXNj bG9zdXJlLCBjb3B5aW5nIG9yIGRpc3RyaWJ1dGlvbiBvZiB0aGUgY29udGVudHMgb2YgdGhpcyB0 cmFuc21pc3Npb24gaXMgc3RyaWN0bHkgcHJvaGliaXRlZCBhbmQgdGhhdCB5b3Ugc2hvdWxkIGRl bGV0ZSB0aGUgY29udGVudHMgb2YgdGhpcyB0cmFuc21pc3Npb24gZnJvbSB5b3VyIHN5c3RlbSBp bW1lZGlhdGVseS4gQW55IGNvbW1lbnRzIG9yIHN0YXRlbWVudHMgY29udGFpbmVkIGluIHRoaXMg dHJhbnNtaXNzaW9uIGRvIG5vdCBuZWNlc3NhcmlseSByZWZsZWN0IHRoZSB2aWV3cyBvciBwb3Np dGlvbiBvZiBSYWRpYWwgb3IgaXRzIHN1YnNpZGlhcmllcyBhbmQvb3IgYWZmaWxpYXRlcy4NCg0K DQo=