MySQL/MariaDB stored procedure or sql where clause
Harald Paulsen <[email protected]> Fri, 02 Nov 2018 12:00:31 +0100
| Newsgroups | gmane.mail.perdition.user |
|---|---|
| Message-ID | <[email protected]> |
SSdtIHdvcmtpbmcgb24gYSBuZXcgc2V0dXAgd2hlcmUgd2Ugd291bGQgbGlrZSB0byB1c2VkIHN0 b3JlZCBwcm9jZWR1cmVzIApmb3IgYW4KZXh0cmEgbGF5ZXIgb2Ygc2VjdXJpdHksIGluIGFkZGl0 aW9uIHRvIGhhdmluZyBhIHdoZXJlLWNsYXVzZSB0byBsaW1pdCAKd2hvIGNhbiB1c2UKYSBwZXJk aXRpb24tc2VydmVyLgoKSGFzIGFueW9uZSBtYWRlIGFueSBwYXRjaGVzIHRvIHBlcmRpdGlvbiAv IHBlcmRpdGlvbmRiX215c3FsIHRvIGFsbG93IApmb3IgZWl0aGVyCm9mIHRoZXNlIHNjZW5hcmlv cz8KCkV4YW1wbGVzOgoKMSkgVXNlIGEgc3RvcmVkIHByb2NlZHVyZSB0byByZXR1cm4gYSByZXN1 bHQgaW5zdGVhZCBvZiBnaXZpbmcgdGhlIApwZXJkaXRpb24gbXlzcWwgdXNlcgphY2Nlc3MgdG8g dGhlIHdob2xlIGRhdGFiYXNlLgoKSWYgSSB3b3VsZCBoYXZlIGEgdGFibGUgY2FsbGVkICJ1c2Vy cyIgd2l0aCB0aGUgZmllbGRzICJlbWFpbCIgYW5kIAoibWFpbHNlcnZlciIgSSBjb3VsZCBtYXAK dGhlc2UgaW50byBwZXJkaXRpb24gZXhwZWN0ZWQgZmllbGRzCgpDUkVBVEUgUFJPQ0VEVVJFIHBl cmRpdGlvbl9sb29rdXAgKHBhcmFtZXRlcl91c2VyIFZBUkNIQVIoMTI4KSkKQkVHSU4KICAgU0VM RUNUIGVtYWlsIEFTIHVzZXIsIG1haWxzZXJ2ZXIgQVMgc2VydmVybmFtZSBGUk9NIHVzZXJzIFdI RVJFIGVtYWlsIAo9IHBhcmFtZXRlcl91c2VyIExJTUlUIDEKRU5EOwoKVGhlbiBwZXJkaXRpb25f bXlzcWwgY291bGQgYmUgc2V0IHVwIHdpdGggQ0FMTCBwZXJkaXRpb25fbG9va3VwKFxVKSBvciAK c29tZXRoaW5nIHNpbWlsYXIuCgoKCjIpIFdlIHdpbGwgdXNlIG11bHRpcGxlIHBlcmRpdGlvbiBz ZXJ2ZXJzIGFuZCBvbmx5IHNvbWUgdXNlcnMgc2hvdWxkIGJlIAphbGxvd2VkIHRvIHVzZQpvbmUg b2YgdGhlIHNlcnZlcnMgKHdoaWxlIGFsbCBvZiB0aGVtIGFyZSBhbGxvd2VkIHRvIHVzZSB0aGUg c2Vjb25kIApvbmUpLgoKVGhlIGFkZGl0aW9uIG9mIGEgV0hFUkUtY2xhdXNlIGluIHRoZSBjb25m aWd1cmF0aW9uIHdvdWxkIGhlbHAgbWFrZSB0aGlzIApwb3NzaWJsZS4KCkV4YW1wbGU6Cm1hcF9s aWJyYXJ5X29wdCAKZGJzZXJ2ZXI6MzMwNjpkYlBlcmRpdGlvbjp0YmxQZXJkaXRpb246cGVyZGl0 aW9uOnBlcmRpdGlvbnBhc3N3b3JkOm1haWxzZXJ2ZXI6ZW1haWw6TlVMTDpTb21lRXh0cmFGaWVs ZD0nWScKCgpPciBmb3IgZnVsbCBmbGV4aWJpbGl0eSBhbGxvdyBvdmVycmlkaW5nIG9mIHRoZSBx dWVyeSBsaWtlIHBvc3RmaXggb3IgCmRvdmVjb3Q6CgojIFBlcmRpdGlvbiBleHBlY3RzIHRoZSBm aWVsZHMgInVzZXIiLCAic2VydmVybmFtZSIgYW5kICJwb3J0IiB0byBiZSAKcmV0dXJlZCBieSB0 aGUgcXVlcnkuICV1IHdpbGwgYmUgc3Vic3RpdHV0ZWQKIyBmb3Igd2hhdCB0aGUgdXNlciBwcm92 aWRlZCBhcyBsb2dpbiBpbmZvcm1hdGlvbgptYXBfbGlicmFyeV9xdWVyeSBTRUxFQ1QgZW1haWwg QVMgdXNlciwgbWFpbHNlcnZlciBBUyBzZXJ2ZXJuYW1lLCBOVUxMIAphcyBwb3J0IEZST00gdXNl cnMgV0hFUkUgZW1haWwgPSAnJXUnIEFORCBTb21lRXh0cmFGaWVsZD0nWScKCgpBcyBhbiBhbHRl cm5hdGl2ZSwgY291bGQgSSBjaGVhdCB3aXRoIHVzaW5nIHF1ZXJ5X2tleT8KcXVlcnlfa2V5IFxV LVkKbWFwX2xpYnJhcnlfb3B0IApkYnNlcnZlcjozMzA2OmRiUGVyZGl0aW9uOnRibFBlcmRpdGlv bjpwZXJkaXRpb246cGVyZGl0aW9ucGFzc3dvcmQ6bWFpbHNlcnZlcjpDT05DQVQoZW1haWwsJy0n LFNvbWVFeHRyYUZpZWxkKTpOVUxMCgoKCi0tIApIYXJhbGQKX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fXwpQZXJkaXRpb24tdXNlcnMgbWFpbGluZyBsaXN0ClBl cmRpdGlvbi11c2Vyc0B2ZXJnZW5ldC5uZXQKaHR0cHM6Ly9saXN0cy52ZXJnZW5ldC5uZXQvbGlz dGluZm8vcGVyZGl0aW9uLXVzZXJzCg==