{"id":743,"date":"2020-01-11T21:28:04","date_gmt":"2020-01-11T13:28:04","guid":{"rendered":"http:\/\/prayerlaputa.com\/?p=743"},"modified":"2020-01-11T21:28:04","modified_gmt":"2020-01-11T13:28:04","slug":"mysql-%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b0%e6%95%b4%e7%90%86-%e8%8e%b7%e5%8f%96%e5%a4%9a%e4%b8%aa%e5%ad%97%e6%ae%b5%e6%9c%80%e5%a4%a7%e5%80%bc%e6%9c%80%e5%b0%8f%e5%80%bc","status":"publish","type":"post","link":"http:\/\/prayerlaputa.com\/?p=743","title":{"rendered":"mysql \u5e38\u7528\u51fd\u6570\u6574\u7406-\u83b7\u53d6\u591a\u4e2a\u5b57\u6bb5\u6700\u5927\u503c\u6700\u5c0f\u503c"},"content":{"rendered":"<p>\u5185\u5bb9\u8f6c\u81ea\uff1ahttps:\/\/blog.csdn.net\/yangshijin1988\/article\/details\/51698061\/<\/p>\n<p>greatest(\u5b57\u6bb51\uff0c\u5b57\u6bb52\uff0c\u5b57\u6bb53\uff0c..\uff0c\u5b57\u6bb5n) \u00a0\u53d6\u6700\u5927\u503c<\/p>\n<p>least(\u5b57\u6bb51\uff0c\u5b57\u6bb52\uff0c\u5b57\u6bb53\uff0c&#8230;\uff0c\u5b57\u6bb5n) \u00a0 \u53d6\u6700\u5c0f\u503c<\/p>\n<p>\u793a\u4f8b\uff1a<\/p>\n<p>SELECT GREATEST(2,3,4); \u00a0 \u7ed3\u679c\uff1a4<br \/>\nSELECT LEAST(2,3,4); \u00a0 \u7ed3\u679c\uff1a2<\/p>\n<p>SELECT GREATEST(DATE(&#8216;2016-05-02&#8217;), DATE(&#8216;2015-05-02&#8217;), DATE(&#8216;2017-05-02&#8217;)); \u00a0 \u7ed3\u679c\uff1a2017-05-02<br \/>\nSELECT LEAST(DATE(&#8216;2016-05-02&#8217;), DATE(&#8216;2015-05-02&#8217;), DATE(&#8216;2017-05-02&#8217;)); \u00a0 \u7ed3\u679c\uff1a2015-05-02<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5185\u5bb9\u8f6c\u81ea\uff1ahttps:\/\/blog.csdn.net\/yangshijin1988\/article\/detai <a href='http:\/\/prayerlaputa.com\/?p=743' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[63],"tags":[64],"_links":{"self":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/743"}],"collection":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=743"}],"version-history":[{"count":1,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/743\/revisions"}],"predecessor-version":[{"id":744,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/743\/revisions\/744"}],"wp:attachment":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=743"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}