{"id":243,"date":"2025-04-19T18:13:37","date_gmt":"2025-04-19T10:13:37","guid":{"rendered":"https:\/\/zhoujibin.com\/?p=243"},"modified":"2025-04-19T18:13:37","modified_gmt":"2025-04-19T10:13:37","slug":"%e5%8d%95%e5%ad%97%e6%ae%b5%e6%89%b9%e9%87%8f%e6%9b%b4%e6%96%b0%e7%a4%ba%e4%be%8b","status":"publish","type":"post","link":"https:\/\/zhoujibin.com\/?p=243","title":{"rendered":"\u5355\u5b57\u6bb5\u6279\u91cf\u66f4\u65b0\u793a\u4f8b"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">\u80cc\u666f\u7b80\u4ecb<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>\u5728\u7f16\u8f91\u5217\u8868\u4e2d\uff0c\u591a\u884c\u6570\u636e\u9488\u5bf9\u67d0\u4e00\u5b57\u6bb5\u8fdb\u884c\u4fee\u6539<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\">\u793a\u4f8b\u6570\u636e<\/h1>\n\n\n\n<p>\u7528\u6237\u8868\uff1auser<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>id\uff08\u9690\u85cf\u5217\uff09<\/th><th>\u7528\u6237\u540d(username)<\/th><th>\u7b49\u7ea7(level)<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>\u5f20\u4e09<\/td><td>1<\/td><\/tr><tr><td>2<\/td><td>\u674e\u56db<\/td><td>2<\/td><\/tr><tr><td>3<\/td><td>\u738b\u4e94<\/td><td>3<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">\u6279\u91cf\u4fee\u6539sql<\/h1>\n\n\n\n<pre class=\"wp-block-code\"><code>update user set level = \n case id \n when 1 then 1\n when 2 then 2\n when 3 then 3\n end\n where id in (1,2,3);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u80cc\u666f\u7b80\u4ecb \u793a\u4f8b\u6570\u636e \u7528\u6237\u8868\uff1auser id\uff08\u9690\u85cf\u5217\uff09 \u7528\u6237\u540d(username) \u7b49\u7ea7(level) 1 \u5f20\u4e09 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[26],"class_list":["post-243","post","type-post","status-publish","format-standard","hentry","category-database","tag-sql"],"_links":{"self":[{"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/posts\/243"}],"collection":[{"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=243"}],"version-history":[{"count":1,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/posts\/243\/revisions"}],"predecessor-version":[{"id":244,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/posts\/243\/revisions\/244"}],"wp:attachment":[{"href":"https:\/\/zhoujibin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}