首页 技术 正文
技术 2022年11月21日
0 收藏 371 点赞 3,755 浏览 13590 个字

测试数据:公司部分员工基本信息

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAO4AAACoCAIAAABojUUEAAAQbElEQVR4nO2dP46DPBPGfSekFFwlKVJxDrq0HGGVlNFXfRLtu9Iq7V6A8tX2uUHewmDG9tgmgO2BzCO02vwjD+NfzGDAI56DhPjHWJ7P5z9CuF5aoq+vr9frtXAlrCdHEkhoDyxGJcr+98wQN8Ba4kgqmaSmETfAWuJIKjHK2xZHUolR3rY4kkp5UGaxVpe4/+//vPCyg0W8WKxdKIxyXdfLv2aVlRh6Pp95DcwQEc9EbEitZSacK8sPL8xjVlmJrYnr/Pr6imRghoh4JmJjnhlGmVEmZ2OeGUaZUSZnY54ZRplRJmdjnhk6KN/PAupw+X0+n7+Xg3x4vuNvQDS3Pe5nZK33s/7U/SzE+a6/wXgGviI/G3Y+nyEVodEG9nWjGfAxy/ZClK3ggOfNrV8/JqRQBtszRkU9b78BR2gRymZQ9S/9vRwO5/MBfu39LA6Hg90Sv5eDet78Pazm+fdyAGv+vVz0iJmGVLz0zy22oVZqBudp/4bu57PH5BIzVFFGCLY23hGNBSgfLr9Gz6J9x+/lcLj8yr/wDefzwfhV/V4Oh8vF6Xwtz7oV1DP2vNPPEpSx4Hi2/GNQBl2IpwHwcCxD2dhNwq8YmklrLvUDsFswjM5iz7+XQzgpMl65uN0sQNkTHHQdO0cZTZ2So6ztf8FXjI0Em6t/g7n7Pt9151BIWrSwO9RD5vs6c3+/lg00ODAoY1IfKyakULZJeoZQXhELowNWXTTCL/jfkwgl6JVHgeM4b698vnvczLbhDo6dOseKCUWUn9pO3rnx2m8eaA2U1UNXzypsbqSfaanRWp6h1Denz5VdwbEPLz8P5WDfhiaJUiuhrA9pOH9H8AX5ATP3iIjy/TwtE3saVK08guHpZMxBv09EuYf14BpXdsfha7ICKIOhZvs1KyGGTxorNDste18y1zMcVVarRb7OSpHxceV5NtzBQfyA3GPlmNBBOYOyG5ghIp6J2JBilPMbmCEinonYkGKU8xuYISKeidiQYpTzG5ghIp6J2JDyoVyzWJuSE2XXC0qeD0+XEJlvIvz+/s5rYIaIeCZiQ8pjZmqC8e8yMcozRMQzERtSjLIWgq4p4TBn1b5er7YSZdOBD3RNqT+xooIxtz1nFBEbUpNQFtZMh3tFGahrSgTlrimFiAYyo7xAU1FGaf4wlNtKRMX49WKUF+gNlG2a30D5py5EUf/kQ7lrSgeGWgj0DGNEuW3K/qGhttKeNh6+rfkouzcwniwbbTWETrOSxNt7KBs0T0P5ehRCFEU+lGVvWk5C2UqM0afAC21TNW1Tiqo1Hs7zOgvlwAbGk23D2u503t5GGdL8ToJxPebtld1EmiiPrWEcBGqS6+qasqoqtV7j4QypgLv+QTyHNjCejCNm99en8DYHZRXW/aGMtUf/wc7ua/t3Dx8yHs7S/AQjN8pNWTadSjCMSFFFece9MpIqqw8iLK+v7aJcAYKt3JgkyjCs+0N51Aiu+mAKlreMMvz21vswuhlDq45g7AFlx4FNDhFEWf+d2wM7lFC2e4ido9y/fcyV+2QwNTCICKIMkwpr/0UJZXRnNw3ln7qAGYoJdHyUjYEIM6ZoCEBjDIcyIA/MTrPuObCBqWygo8rpvPE1GNZgnBF0pEPpXOdLkonIaTYiNqQYZVrtMVFEPBOxIcUo02qPiSLimYgNKUaZVntMFBHPRGxI+VBOcxOLEOKbxVpDTpSDv4O1boj6e/1lXL6/v/Ma2K5nIjaUGSdjyRKM7CHwvuF2EkXd5W+qdzx/lg1lhlEmhHIw5tM8EwldajOMMmyPR+2+sBPodItjhlFeYoZRdrdHVxdlUYiiKMWpTWGGUV5iJjrK16PzrHUalG8VMGClCq72uFVClPVjSDBulRDVzXrb7aT10MbDt5d5KPs3MCo9VjQGH81DPvlohusWyvoR2UxklK/Hkd/rUYjjNTHK7UmF9a892bmB1R59jjF0wyBXbk9CjEDfKlE0t7qqb00hqpvxcJ7bOSiHNjAqPeDh7STMfdejKQaCH3WJ9gVrmkmZYFyP6VHWFqTXhO1xqyZ0bADoR1OcqhPsgeDDGYsMrHDfEIUxFNjAqPSo/x9NYW34o4aJWVcXMb2lRRm70jMpyu3J3s1hWIw7SlPw411dlPXj9ajLou6sh7MczumVQxsYb4E26rKoOxU3iawx+BN3LCglyvglywlRxkM58dhF5qOxD/6WoZx6CBzaOIGBnSGvsA8k9oAyliYnRRnJ5LxYmJ9Nc0S1AGXnBsZbdJTtDtjulTefYDhvIUmFsq8/MBK+KaPK8Ag9y4INHWQ4JaknGPCHJKm1cuWYyU8ClH0cJ0E50MyhXllvDxqLNXSQ59S62QsMpD6GMRz45K2K+/uPjjIYVJZKPYIBxlzhEYkLC3uhjnJwA9PY0JyA3nd8MuZI3B+f7bPbw1qoo8w2lBlG2X22L3k/t9DzZ9pQZhhlQu2xLc9EbCgzjDKh9tiWZyI2lBknynxDFGtbcqLsekFprRuilq9kiTwhICsinonYkPKhnCzBSLi9iEi1x0QR8UzEhhSj7J4tyqNoUxMFY456ziUiNqQY5VB7pK3xwSjPFqPMKM8XERtSCVCGM3ki18bFRxlOJolkBstQ5gpRSnpqBuekjp2WIWY0rYPyT31U1xKhFc9io9w1lTZDqtXcs1HmClGWDXOz4UTLsYsGJE4w4I1+yXplqNau37SkV+YKUboBE1Wz4FZMg0lR/qkL+3LPlCijwTRD4Ctxpu8puUKUM8FQAMNatHHtpUBZJcvoZcsJUFZworHcy2FfdpQ1K1oxhxSpcvJeOX2uDLVurhxD+0BZmYGeYgcyea6coRYJFNLepFCeqC2gXLVpS54lGMGor+P/WUYwGq3SL+1eeaIootxWMEEWVWvELnYFl/i9MhxWxpLl6L0yPIzD2nr7KBOpEIWOIKPHggnMaPrEs30TRi+S8xLynFFEbEgxyrTaY6KIeCZiQ4pRptUeE0XEMxEbUowyrfaYKCKeidiQ8qHMN0SxtiUnysHfwVo3RGW/vTH7LZYb9UzEhjLjZCxZgpE9BNmbYaOeidhQZhhlrD3gvNZdXWiTREWcMzMYc1IMEbGhzDDKIZSNubZiFklglJeYYZQDxc5OrUZ21BkpGeUlZhKh/FMXuSpEyeXRFG9UiLIKZ/QVorq68E1/zRWiBh/9rx12DXGn3kuF8k9dFAVyMVEylIcKfLNRHtuJK0ThoUMrRJ1UwOFcy5HMpED5eizqn5y1SG6VXU8AaQ/HrPegxIa+Bq4QBUMR2vDbafMo9yXO8qHcnkR1e7Osjj2tcr+vHBuMK0QFKkRpywTWl5qJjbKq1ZcLZdVRTUJ5iLiJcr9/jLwHX4YytQpRw/9C7wKimYmLMrg1NQ/KoDOYhPIwQAGOV/SjPUeF4HWWBSgTrBBlNsS2c2WzFIk1rUtslO1ikkZ7I4Nx1U3vlR91qecVmcrYODzj6CS2gVWIMt6/k7p92XrlYCjtw3AhxKkFKPep9viR2GnfWwzRrhBV37A3RDLDKGsDW6KsH11/Exe1ajqoZ9IVojpwO1zk41E+22dgoVhHTvtpily66y2GPtyGMsMoE2qPbXkmYkOZYZQJtce2PBOxocwwyoTaY1ueidhQZpwo8w1RrG3JibLrBaW1bohavpIl8oSArL6/v1+vv+wLqdD5UE6WYCTcXkSk2mOiGGVbjDISAnP2tWG+9mEqtIgKxhx4ZpQ1McroVOH6NFo9yl3XxZ7Cj1GeL0bZW7dPIt2jDF+JNWUcozxbCVC+alcURZ+UdgRO4QYYRBDUQmDkENp0iCi+GStEEUTZDj5eNiqG0qCM1DiLgzKWzcJKOtjrMARtJcrSnsMWn7o4d4UoaiijhxJLf9vTtSuUJxS0QSJrh8BaTzewCi7BaPsX8lWIooWyI/h7Q1kpbgnKpiybTgGHRRDrXr0oe/PjzBWiaKHsCP5Opwq/HuPmyhWIFzZZPZ4nGAmGJizD6JoyXptsF+VQ8LWyUTGUeAQjblkdbxEX56DwhARjXFns9tgyysEKOhsvq2OhbOYYqyYYEFaYpfmCOAll1V8nqqcYEEGU3cH3P7luTHCthPL1qOC9HpFsed3DPq3yYR+3AHdOlCHRclQOWXkeEUQZDz5SNipqTHBFOOzDRjLWHVcODWwiBx/oiWt9lEI+GE/1pTssd4ggyi90SB8vGxUvJrg+9Gyf2aELK+NO0Cwh0UQ5rxhlvjKOUWaU84lRtsUoM8ofgDLfEMXalpwoB38Ha90Qlf32xuy3WG7UMxEbyoyTsWQJRvYQZG+GjXomYkOZYZTdU4XDuaGSTF0cjDkphojYUGYYZedU4dpsWozy1NBlM8MoI+3xaApzHkFGeVroMppJgPJ47tqeynNtlI0iRTdrfmVzokukPbq6ALO095OHj5N8kqsQlZEeb/D76I2NH3Pm3AQooxcRRUI5MPM7WnLPxkKfCXiYyrbvlcd5l6lUiMq36Daw4CesXhUdZVDAITrKgRm8HbPVoygXTX0SqnTD6fYaE4wHIJVehaiki3HEHK4QtWmU60KWOXNeGrciyv4iRQ9HZ2lgMQxigAox8lMqV1a9C8EKUWkXaCNYISr2wUZ0lI+A4J8aKUK5IsquIkV/rz+seBnSHjIDgR3MmJOMLRGxYMJ2UfYGP27QlJnYKEN48Rui1toYX5Eid6LmSDAefy89JwGdSrwy11tG2VMhKkX1qgQJBswq8Bui1toYT5EiD3welLXeBaAcu0LMWwxlXPQEwxX8RFV/Uhz2qY74R+d6dZTRIkV/r0B5Ml+vDJe0hUqnM0TEhiP46apXpRhX9o0qrz2ujBQpChWNtLHAu3BGOWTDDn7K6lV8tg8tHAY7krFUVN5afR6GPtyGMsMoE2qPbXkmYkOZYZQJtce2PBOxocwwyoTaY1ueidhQZpwo8w1RrG3JibLrBaW1bohavpIl8oSArIh4JmJDyodysgQj4fYiItUeE0XEMxEbUoyyGQKtZoNTsWYnCsYc9ZxLRGxIMcoYyn5QY05+yCjPFqMcRDn8xIpilGcrOspHc9cccX5l8yypPhWnKzFwoIwnGv1ktdrMzbkqROlCZ5qPLN0GXgxqjGNkd0l7ZeQSz2i9sppUuWsqFUK0uWf3yrkrRMFtFaIsCaBsbjYIePTqnQlRRi+8j4Sys4tq7fpNKMrug78Sopq1QpS1aeRQ1nuByBOsp0MZvcIzEsquoKHFm+Yf9mWuEGWIAspGImeXg9lDLRIXyTFQNmlUXSwaSCfK1nz5QhFM8bAvO8qaFVE2HXIgsQOU3TMIrI+yu+jFxFy5f4sRedgZM8pOG9CM3StvP8FAD/gioextUuRFIwTjO3KgPFFbQLlq7Vx583X7HAd8UVC2Ot6uaVrni3YIABA5EoyJoogyVgwKBjy2vxQo+6cnWhdlJLmAgxFYLI32GN/jij05lI3hlnRAOw/79Ap+9pPxzWj6xLN9vmwOAJO1/OTrReY0GxEbUowyrfaYKCKeidiQYpRptcdEEfFMxIYUo0yrPSaKiGciNqR8KPMNUaxtyYlynB8Pi5VajDJrJ2KUWTsRo8zaiRhl1k7EKLN2IkaZtRMxyqyd6D8D504ClNAiRAAAAABJRU5ErkJggg==” alt=”” />

现在需要查询出退休员工,查询SQL(年龄大于等于60的男性和年龄大于等于50的女性):

select *
from person t
where (t.sex = '' and t.age >= )
or (t.sex <> '' and t.age >= );

由于数据录入不完整,存在以下两位员工:

5    62    钱**        65
6    67    孙**         62

导致查询结果为:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQIAAABvCAIAAACIMFk3AAAL1ElEQVR4nO1dO46zShPtPSE5YCvjwBHrIHPKEkbj0PqjXyK9I1lOvQHCq8m9A27Qpql+QbufBa4j9H0D5nGo6tNd3UAXG8dxHMenAxj7R9nyD2Or+3jg+/vbkRJhGWRJRzB3GWQDOS8WyJKOIBnsGWRJR5AM9gyypCMwyoBAyAyDDK7/+z8ttHzUYpbBSCB8EkJl0LZtOIkoJ1HwfD7LEvAAEs5IaHDkIbMkA5egil/YJxyLfRIdjuf8/v5ORMADSDgjoeFHhmQgAZUvHYGEMxIafmRIBhJQ+dIRSDgjoeFHhmQgAZUvHYGEMxIafmT2IYPriUEczo/n8/k4H/jq6WrewQBfX15PhrNeT/Km64mx01XeQdkCf+HHrjP3L3/CQjMN0+VmMuAwjXagDDTjgO3q3ce3yW5kAGwxW1Rs13cwF78gGagOkS/6OB8Op9MBXvZ6YofDQffi43wQ21UtReP8OB/AmR/ns2wxlZCwl3xcMA1xUtU4T11/19NpgWQImT3KwFD6NcNZLBkgg8P5odRo0jUe58Ph/OD/wh1Op4OiyMf5cDifrcxjcZapGDmbtlv5hMjAZJyFOycZmE+iFjjQxNucZzZlmAyUph1eYnKx5GohHt3768UumPPjfFgP5JRfznY2ATJYMI7xHCQD80lMAeRre14ZSDEDuMTsYOjq1w5qyHG6yswhDKFcQPmbegdS4bNeTo1RYtEwGgcaZe7EpLLJbmSgl8LnmgwiFiml4hdNg6Hsg78XgrcMrcEM0OddbA1O1wU23jTsxtG7CqlssjcZPKXAxGo4qa4BiCEDsWqr0Zle5jgft3AuFmcIceX8fQObcfSuOMlg5STvdZGNQTFHJBnIQ0dWDcIf+AFqvJRQBteTW/T4VEpk5JGihQpKHZglGaycxGRLdjjYnhvYbfjtjBUZgEcJ+m9aBwBuVE6oVpZ6G+bLGT41EKc1XE7rEpifG/jRsBvHwAfES5Ftsg8ZFEBxAh5AwhkJDQ6SwbYJeAAJZyQ0OEgG2ybgASSckdDgIBlsm4AHkHBGQoMjvgxaAmGDiN8auMD7whIJxsJPEoLf39+yBDyAhDMSGhzeZOIERf+GgWTgASSckdDgIBkEAZpv6Go4jN304zj2Dau7ARwwdLW8ISJWba5zLggkNDiSy4Bps/buVQYAQ1cbZDB0NWPJREAyCEAOGRiV8GEy6BuWVALjSDIIQCYZ6Ep4Qwa3tmJVeysng6GrLUVYMp8cFc0y6Lv6taqgb6TNyurb8JeB/QbTQaPRN5PpJCpZuOWTgaIENxn8fDHGqqqcDHgtXjvJQOsIGDeBH/qu6fquZk2vrPpx9ZLByg2mg05Du+983LLKACrhnaDo56tsa2AvzaoMZk8qHWYJ/FxDVzdNI86rrHpAGNz2h4Hz2g2mgzK6YL98Dm65ZSBcsj8ZmHz5OnDQ6/jX3tNByqoXvFqDlRtMB0ijq+tuEEGRYqk9ymDHrYGhayAONOggPrYrgwaUfq0vsDsZwO37k8GMudCLA3PoYMsygFfvF1eTk3kLGUeK9iADSyewBBDKQK4j9AG0vchAr5l2LoPX7nPf4BX85i5sBiCUAQyEtHZzLzIwNtBuMri1FYyqVDGkl4Ey4KP6w2g+4Mip2wfi3uJKkDmv3GAuGsanBvm40TtFQVAHTBWHGSqywfYsLRuQPL5FQoODZBAEVL50BBLOSGhwkAyCgMqXjkDCGQkNDpJBEFD50hFIOCOhwRFfBjk/nGOM/RIIMRBZBo6I9RHm3/hXcPn9/S1LYLuckdAQZDxLIP+veFBU3HyLO1yOrGqH8m5+h/Nn0RBkSAbpfJlVBqs2d+OMxHS5yZAMYvny3tpfrgY4XtKQIRmEkCEZpPHl0FZ1VbGqqtmxz0GGZBBCBrUMfr6sb1LkkcGlAQS08Mbmy0vDWN3ep6Do0jDWXLTdLkepZVBW3178ZLB8g0lLnmaNiUd35xvv3fQuTd3eE5NBLIOfr7ns/3wx9vWTWQb9Ubjkrz/q8Yzmy1dcNFX/oG/QHxmbxXBpWNVd2qa9dBVrLsqqH1sfGazdYNKSB1YvR6a2mfeumkr/va2N9UhMMohloDYM2WUgLYbaGvry0jhUqEAM9646NkdY88FVj4Ubltk/wjSVv5UbTFryxN/3rtJu/N7CYHJoq5TctiMD09vWWWXQH/Wm2VSk5sZdBTx8aKu6vY/3tq7aQVv1Yrhqcztn6w2mWyCNtq7aQdiNF3dlkC3tmNtWZGD+5CCjDMxucOzn8fg7dUc5TAa5H3FAGkcwgDbFQnrH6dNlYOoWZJWBIXJdLFLqsXl6nwEysN5gukWWgV7x663BRwdF1k/PcslgqR5SAlyXpwZwJKTIYhqiKfCoWw6KoAh5idf6BikDNuQyWNJAFhmsFJG11kD2JY5FG6Ip87qHWoNMpfw+jZXBjZcmbd2BWgbgoQFH7pEiMKYOe2+2IqUv2GWweoN5aEhMQK0/b0w5WvqHXAaryDpS5OBLbcEuA6IhyJAM4vsS1LL56tdAzp9JQ5AhGezEl9vijISGIEMy2Ikvt8UZCQ1BJrIM6CNMwhYRvzVwQayPMMNPEgJv8xUEEs5IaHAkkUHOoCiKFbyBypeOQMIZCQ0OkkEQzOaD03AOXa3OyJlq0rpVmy9xzg4kNDhIBkFYl4EyNW3Kea1JBt4gGQRBNp8h0VPTq1P7ppuQlmTgDeQygDNaG94xzSYD21TUDq3BOIo2QE3kgiIT5jwBcd65tjXT6TMhw2ol7ezHqGVwa7/Ee3XGrLCZZDB0tSUfo6MMtBne0WTC7EHSwbyJSGTTGa49dI00xXtKkaKWgQz4YXJWGfQNz9GxIgNL7ktragNMmTCnGy0kA4fMh32Qad4h8xZyy+DWVvor1zlk8Cob6zIA0JuDl0akFBaIMmFOd5oxLII0FjNhjqOTTqKReQuZZCA6B8bPDtLLQFSQTjIAhVpy5qtNTxx1hMkgd94nSMOWCVM0sKmZYZeBpIfsQRGohJxkAPO/zlUbcGxSIQTIoEB+QlkGK6kvqW8gYPgSLbUM1I9StLJiGDBVhkgVD6b2pwNMQzQFKMlB0UImTLHxU3Of3dr2Z/673EjROLq1Bq/otunlJwVaL6GsDjTOZeioowtaJsyh63rTDqnJvIUsrQF8bGDqHOCSAd9lCohQ5EA2AXLu1fau1ICpKRMmHHpLLFXcMlhDRhmYIRcpowMXBlHLAMnjWyQ0OEgGQUDlS0cg4YyEBgfJIAiofOkIJJyR0OAgGQQBlS8dgYQzEhoc8WVAH2EStojIMnBErI8wi3/KXfxz8o1yRkJDkPEsgfy/4kFRcfMVd+FGOSOhIciQDOL4Up3KF049myV1wKrNUZU/JDQEGZJBdF9qSYpIBq6mK0aGZBDZl/euUudsJBm4ma4gmQ3I4NZWWTJhKskY9fRNDjNaD20FMhi8ZiTnMhjaail1RZlMmAVL3qLxX9ab36VJOfv8FmRwa6uqMrxYF1kGKxlfjFPs60UKzso/Zw94tQbzBNdYMmGWW2QaJuNnzNK5ARn8fFXtLXnuM1MyRrCoFbnRl+I87ZEx1lzm/I1TUHQHpRxfJsysizK6sHbjH5706ZUGNrkMTMkY5+VuqaSVIjUNFoFsdvwo0TcQtRrCTJh5F0hj2fiSAZORwSwDkQs5uQxMyRjFr9ZsHdCXPGqCFdscR81eTJhkabsyWDR+WqMJMnhlAD7DzyADexZee2BqCYruf6McR4HKLF0ary3LYCEFco4snahloKY+06bsihoU6ckYX6sLBXdBBlKtBmRgqu2Klb+CixwU2YyfKUMhahkA5Ogi68kY/0Zr59hWpMy9vbwJ6N3LHxIaFuPny9JJMpgXazJG+wimXqTMTQfJYI2GbvycWTq3IgMzUD1FntwGK7B7O32NWTYl+EL5+3AaggzJYCe+3BZnJDQEGZLBTny5Lc5IaAgyJIOd+HJbnJHQEGQiy4A+wiRsEfFbAwLhQ0AyIBBIBgQCyYBAGEkGBMJIMiAQRpIBgTCSDAiEkWRAIIzj+B+ik0QZfQPVCgAAAABJRU5ErkJggg==” alt=”” />

以上的例子说明:在oracle数据库中,null不满足等于’1′,也不满足不等于’1’,而”不满足等于’1′,但满足不等于’1’。

另外一个in相关的例子:

select  t.* from person t where t.sex not in ('');

查询结果:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPsAAABZCAIAAAB3xMUUAAAJnElEQVR4nO2dv46zOhPGfU9IFNzKUlBxHXS0XMJqKaNTHYl6pVXa3ADlUfrcQb7CYMb/wLGxGT7mUfS+gbDwMP4xDA7E7EUiXUns9Xrd/vmXXvS6yGsi/k0iXUMfE980TfhWd1mJotfrdawBDyHxjMQGV2wzEvEuZRDfRmAttctKdDmu8/v7O5IBDyHxjMSGnxkifkNEPFobfmaI+A0R8Wht+Jkh4jdExKO14WfmdMTfKgaVt4/X6/Vocz5Z3cwLGOTbbLfKsNZbJc+6VYxVN3kBZQ78hP/ttnN/1ESEFhumzS1mwJ9ptgOJ14ID5qt7v39Mzkg82O0leGK+voCZtCDi1djLG320eV5VOdzsrWJ5nusN9mhzMV89bHbz/GhzsOZH28oRUw2JeMl/F2xDrFQNzks/1G5VtWIyxMzJiTeArsXIErQA4vP2oeQpaRuPNs/bB/8XLlBVuXLwPdo8b1ur8708y1aMnk3zrX5CiDcFZ2XPiXiNLXCOtrWTOWphxCvnZriJuTWlVhXHid7Q24QFe360+XYlpnzS2t0EEL8SHOM6iHhjsTfNT0u8dNIHm1jaErbqtIBaM1Q32TmUoRYLTK5yyNY2pxYZe9kwBgcGZbngiBWTMxKvA/faIn5HepR0LhK+AXPwfqX6SpDjF4FL0dUcX91W3HjbsAdHL+tjxeTExL+kysIaIymDAO1BvJi05Wmm48X9uNVje3mGEltOX8fbgqNfIRPxvleuxgKWayfi5c4b6+EGP+B/oBY8EYm/VW7l30uBb+e+mpVcpPaCEvF24DjTua0/3h6ub2dtEA+66PXPtGIdzlRWqKZA/czk6xn2xovVGjanle/m/ng/G/bgGPyAgmfnmJyO+AN0uAEPIfGMxAYXEX8aAx5C4hmJDS4i/jQGPITEMxIbXET8aQx4CIlnJDa4gohvSKQTKijHu8hjG4atMha+khD9/v4ea8BDSDwjscHlYcazqvkvTOiJH2pWdGMiM45CghoSG1xEvKtQEb8Zc74YEtSQ2ODak3jG2GWIH7tC/a7cpHqIY4aI99bOxBuh/38kXtbYFUVRsKIoojEui4j31v7E69B/QPxfk7Gs+TuG+KEWe2CoT2yRGmq++FTVDLUxsw+1NFeZ/Fh+xK/vYDxpoVuMCB/LSTOytSjEK9C7Ef/zxRjLssOIH+ol1CZstUhNbTQvB+p43qDSB0NXd0NXsHpQJv3M+hC/tYPxJIfOsO2xK+bgjV0R11os4iH0n1Q1P1/H5XggQw6GkRpqh1wEuB+7oq5rmM/gpIdEwG1vdM+auWOIH7tC2/FROvbHgEzwoRlHuRIvon8+4k39LqZIgTJBEfzzqZHntlYmveST47d2MJ6gja4oulHEjZOtuIlrjnK8LnPEHSMlVzSxFEZ86q8OoA0YnrmY0S9yTkg8nH8q4q0VrkOkOO0pYAogPm0Jr9kwpXM9x5+tqlGifx7i17KLUozaypmV6ia9TJ0kBziSqxqIM4dbq+NjesTWH38g8Rs0bEUq8gWXl7ROkmMOQDVZzC5EyODM2C7xfOf612QwOarcxyZeuwjd7J1UhJ34zR1MY0NyAtBeZkb2RffVuOrsxB8oJDa4iHhXrX3nmjxrOgoJakhscBHxrkLVbI5C4hmJDS4i3lWoms1RSDwjscEVRHzKJ7UYY78k0h7yJ95Rez3193w/D3z9/v4ea+C8npHYEGY+Zu+oqubwSB3eWif1jMSGMEPEBzTb2GSs7MX7ugef9iVj5RDFzGbMUaGGxIYwQ8QHNBsk/n1vCoD4ULLlo51fRHyIGSLeo9nujXZnTTlIB0Bfs6y7RzJDxIeYwUL8z5f1FoOUxN+7jLGsGd2aTcrxz+f72deM1f1zbDJpJX0pLaZMfvzyI76vQYS1HYwKmTynL4WPKSnADBLrxCjM4CD+52vB/OeLsa+fQ4gfm6zIsgDil+aca/q+ZlnXN3XTdxmre2XSz6cP8UO5nHNiVlxGyJT4KJc3964UAb93GSuae0wzOIhX0/0xxPd11ox9uUX8vZPuelOSk36WuHdZWS/AKZMeLx5YZn/qz4QafIWeZD6FDIZia8f78nLEm24ZTkH8ULK6f763iQcv+Wp1ngPO1/y80dzf96bImlGb9LLqk+OVPY1J1UromoLnFGsB43BIhJrBRrz5Fvn4xIu050T83DAq8dNJOXLZEEa8eQejQibel8rJcD7wxGkzKu5PfMSbSvgkxIPU4kT83BUDLrnkC9bpEjaO2wDiI35LsAKZeF+qF/RqqC9Vx1sfgEpAvOg9kHobLc02gV73co6/N4VczKRNpeuo2QhLbEM+JRovJ+KaxEP8Gu4JiN+MuN7hwBgrB0D8dBmw/EnskvQj1I7C/alf9MNKpu6f7+e9a3rTApHMoCAedMZzHdQ7aSdD6eljRXMfpwcVExcJH7WueN+rT/0d1TsJnAiyR/DIZ+RLaizEbyoh8S70iEPC8OWrpGilvAdqF7chzBDx52u2c3lGYkOYIeLP12zn8ozEhjBDxJ+v2c7lGYkNYcafeHrqj3RGBeV4F+311F/4SkLkEanDhcQzEhtcocSnrGp23vUPharZHIXEMxIbXES8q2Ck1F9aTffr55M2Y657PlBIbHAR8a6yREobxYWI14TEBhcR7ypjpAyjFhHxmpDY4MJDPPxtYcPdk3sTr/zArT6+jcNvC49dASqaZbC/ohvh70NPHx4/1t9R0mwYfl042TiEWIj/a77EbWTGIS53JX5jnAxjmtYjJVM9/9H0//JTw1jG+jtOsg1T8BOOQ4iFeFnwodf9id8YhEJNz5OMxBddV/PzgSB8Jh/+uja+sf6SSrnodxgk8WLE/zWZft/wjsSbhptbZPsdeCVSc3cNGMRLGbhO5CqEY/2lFbSxHvz3O/qFECLiRSFvvE1+R+JNw80JWQc+gJEStbpaxFve7a7zEr8a/HeCC39ExEvox6xq1kYPtReRlqpGDDRtGMcoXuudmfiVLy9SjEOIkXjj81C7VjX6cHPLhI3RFeKlXAVWYbkiSCeExNuDn2hgNizE/zXNz/I+bo43DjenfqBpLcdDHTainkEIibcEP13UsBAvdcebCvl9++Otw83Zz6l6pMytRMRrUmzowU85DiEa4reE6jvXuYUg2su9NmiAR0r8sSLiXYWq2RyFxDMSG1xEvKtQNZujkHhGYoOLiHcVqmZzFBLPSGxwBRFPT/2Rzih/4kmkK4iIJ11LRDzpWiLiSdcSEU+6loh40rVExJOuJSKedC0R8aRriYgnXUv/Ay1UQNeN05NFAAAAAElFTkSuQmCC” alt=”” />

not in 和 <> 类似,所以以后写SQL时,需要注意。

相关推荐
python开发_常用的python模块及安装方法
adodb:我们领导推荐的数据库连接组件bsddb3:BerkeleyDB的连接组件Cheetah-1.0:我比较喜欢这个版本的cheeta…
日期:2022-11-24 点赞:878 阅读:8,999
Educational Codeforces Round 11 C. Hard Process 二分
C. Hard Process题目连接:http://www.codeforces.com/contest/660/problem/CDes…
日期:2022-11-24 点赞:807 阅读:5,511
下载Ubuntn 17.04 内核源代码
zengkefu@server1:/usr/src$ uname -aLinux server1 4.10.0-19-generic #21…
日期:2022-11-24 点赞:569 阅读:6,357
可用Active Desktop Calendar V7.86 注册码序列号
可用Active Desktop Calendar V7.86 注册码序列号Name: www.greendown.cn Code: &nb…
日期:2022-11-24 点赞:733 阅读:6,140
Android调用系统相机、自定义相机、处理大图片
Android调用系统相机和自定义相机实例本博文主要是介绍了android上使用相机进行拍照并显示的两种方式,并且由于涉及到要把拍到的照片显…
日期:2022-11-24 点赞:512 阅读:7,770
Struts的使用
一、Struts2的获取  Struts的官方网站为:http://struts.apache.org/  下载完Struts2的jar包,…
日期:2022-11-24 点赞:671 阅读:4,848