{"id":1493,"date":"2022-11-06T23:11:00","date_gmt":"2022-11-06T15:11:00","guid":{"rendered":"https:\/\/qaqaq.top\/?p=1493"},"modified":"2022-11-27T12:40:59","modified_gmt":"2022-11-27T04:40:59","slug":"%e7%ac%ac5%e7%ab%a0%e6%8e%92%e5%ba%8f%e4%b8%8e%e5%88%86%e9%a1%b5%e8%af%be%e5%90%8e%e7%bb%83%e4%b9%a0","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=1493","title":{"rendered":"\u7b2c5\u7ae0\u6392\u5e8f\u4e0e\u5206\u9875\u8bfe\u540e\u7ec3\u4e60"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code># \u7b2c05\u7ae0_\u6392\u5e8f\u4e0e\u5206\u9875\u8bfe\u540e\u7ec3\u4e60\r\n\r\n#1. \u67e5\u8be2\u5458\u5de5\u7684\u59d3\u540d\u548c\u90e8\u95e8\u53f7\u548c\u5e74\u85aa\uff0c\u6309\u5e74\u85aa\u964d\u5e8f,\u6309\u59d3\u540d\u5347\u5e8f\u663e\u793a\r\nSELECT last_name,department_id,(salary * 12) AS \"annual_salary\"\r\nFROM employees\r\nORDER BY annual_salary DESC,last_name ASC;\r\n\r\n#2. \u9009\u62e9\u5de5\u8d44\u4e0d\u5728 8000 \u5230 17000 \u7684\u5458\u5de5\u7684\u59d3\u540d\u548c\u5de5\u8d44\uff0c\u6309\u5de5\u8d44\u964d\u5e8f\uff0c\u663e\u793a\u7b2c21\u523040\u4f4d\u7f6e\u7684\u6570\u636e\r\nSELECT last_name,salary\r\nFROM employees\r\nWHERE salary NOT BETWEEN 8000 AND 17000\r\nORDER BY  salary DESC\r\nLIMIT 20,20;\r\n\r\n#3. \u67e5\u8be2\u90ae\u7bb1\u4e2d\u5305\u542b e \u7684\u5458\u5de5\u4fe1\u606f\uff0c\u5e76\u5148\u6309\u90ae\u7bb1\u7684\u5b57\u8282\u6570\u964d\u5e8f\uff0c\u518d\u6309\u90e8\u95e8\u53f7\u5347\u5e8f\r\nSELECT employee_id,last_name,email,department_id\r\nFROM employees\r\n# WHERE email LIKE '%e%'\r\nWHERE email REGEXP '&#91;e]'\r\nORDER BY LENGTH(email) DESC,department_id ASC;\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[47],"class_list":["post-1493","post","type-post","status-publish","format-standard","hentry","category-mysql-code","tag-mysql"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1493"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1493"}],"version-history":[{"count":1,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1493\/revisions"}],"predecessor-version":[{"id":1494,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1493\/revisions\/1494"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}