{"id":40165,"date":"2020-02-25T04:26:27","date_gmt":"2020-02-24T20:26:27","guid":{"rendered":"http:\/\/4563.org\/?p=40165"},"modified":"2020-02-25T04:26:27","modified_gmt":"2020-02-24T20:26:27","slug":"%e6%b1%82%e5%a4%a7%e4%bd%ac%e7%ae%80%e5%8c%96%e4%b8%8b%e8%bf%99%e4%b8%aamysql%e7%9a%84update%e5%91%bd%e4%bb%a4","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=40165","title":{"rendered":"\u6c42\u5927\u4f6c\u7b80\u5316\u4e0b\u8fd9\u4e2amysql\u7684update\u547d\u4ee4"},"content":{"rendered":"\n

\t\t\t\t\tbob1987<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:09:28\t<\/p>\n

\u6c42\u5927\u4f6c\u7b80\u5316\u4e0b\u8fd9\u4e2amysql\u7684update\u547d\u4ee4<\/h3>\n

\t\t \u672c\u5e16\u6700\u540e\u7531 bob1987 \u4e8e 2019-12-10 19:19 \u7f16\u8f91 <\/p>\n

\u6279\u91cf\u66f4\u65b0\u6570\u636e\uff0c\u6839\u636esoftwriter\u7684\u4e0d\u540c\u503c\uff0c\u4fee\u6539\u540c\u884c\u7684yunfile\u503c
\u6211\u8fd9\u4e2a\u4ee3\u7801\u53ef\u4ee5\u6267\u884c
\u4f46\u6211\u9700\u8981\u66f4\u65b0\u7684\u884c\u6570\uff0c\u6709\u5341\u51e0\u4e07\uff0c\u5199\u4e2a\u5341\u51e0\u4e07update\u5b9e\u5728\u662f\u591f\u7d2f\u7684\uff0c\uff08\u5341\u51e0\u4e07\u7684softwriter\u548cyunfile\u6570\u636e\u5df2\u7ecf\u6574\u7406\u5230excel\uff09
\u6709\u6ca1\u6709\u5927\u4f6c\u53ef\u4ee5\u7b80\u5316\u4ee5\u4e0a\u4ee3\u7801\t\t\t\t<\/p>\n

\t\t\t\t\t\u9526\u5b89<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:11:04\t<\/p>\n

<\/h3>\n

\t\t\u90fd\u5199\u5230excel\u4e86,\u8bfb\u53d6\u4e0b\u8dd1\u4e2afor\u5faa\u73af\u4e0d\u5c31ok\u4e86<\/p>\n

\u6ca1\u5fc5\u8981\u975e\u8981\u8ddfsql\u8f83\u52b2\u5427\t\t\t\t<\/p>\n

\t\t\t\t\tjimi<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:11:58\t<\/p>\n

\t\t\t\t\tbob1987<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:12:42\t<\/p>\n

<\/h3>\n

\t\t\u9526\u5b89 \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:11
\u90fd\u5199\u5230excel\u4e86,\u8bfb\u53d6\u4e0b\u8dd1\u4e2afor\u5faa\u73af\u4e0d\u5c31ok\u4e86<\/p>\n

\u6ca1\u5fc5\u8981\u975e\u8981\u8ddfsql\u8f83\u52b2\u5427<\/p>\n

\u5927\u4f6c\u7684for\u5faa\u73af\uff0c\u6211\u4e0d\u61c2\u54e6\uff0c\uff0c\uff0c\uff0c\u8fd8\u671b\u5927\u4f6c\u8be6\u7ec6\u70b9\t\t\t\t<\/p>\n

\t\t\t\t\t\u9526\u5b89<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:15:46\t<\/p>\n

<\/h3>\n

\t\tbob1987 \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:12
\u5927\u4f6c\u7684for\u5faa\u73af\uff0c\u6211\u4e0d\u61c2\u54e6\uff0c\uff0c\uff0c\uff0c\u8fd8\u671b\u5927\u4f6c\u8be6\u7ec6\u70b9<\/p>\n

\u4f2a\u4ee3\u7801:<\/p>\n

\u8bfb\u53d6excel \u83b7\u53d6list< softwriter , yunfile >list
list.for {
update tb_xxx set yunfile = #{yunfile} where softwriter = #{softwriter}
} \t\t\t\t<\/p>\n

\t\t\t\t\tbob1987<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:16:02\t<\/p>\n

<\/h3>\n

\t\tjimi \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:11
\u697c\u4e3b\u73b0\u5728\u7528\u5565\u7f51\u8d5a\u76d8<\/p>\n

yunfile\u53ea\u662f\u4ee5\u524d\u7528\u800c\u5df2\uff0c\u540e\u6765\u6211\u53d1\u73b0\uff0c\u7f51\u76d8\u771f\u4e0d\u5982\u76f4\u63a5\u5f00vip\u5236\u5ea6\u554a\uff0c\u6240\u4ee5\u53ea\u662fyunfile\u5b57\u6bb5\u7559\u4e0b\u4e86\t\t\t\t<\/p>\n

\t\t\t\t\tcherbim<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:16:08\t<\/p>\n

<\/h3>\n

\t\t\u7528python\u6216\u8005php \u5199\u4e2a\u5faa\u73af\u4eceexcel\u8bfb\u53d6\u6587\u4ef6\uff0c\u5e76\u66f4\u65b0\t\t\t\t<\/p>\n

\t\t\t\t\tGrobyc<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:17:26\t<\/p>\n

<\/h3>\n

\t\t\u5199\u4e2afor\u5faa\u73af\u7528softwriter\u548c\u5bf9\u5e94\u7684yunfile\u751f\u6210sql\u8bed\u53e5\uff0c\u6267\u884csql\uff0c\u5b8c\u6bd5
yc022t\t\t\t\t<\/p>\n

\t\t\t\t\tbob1987<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:17:31\t<\/p>\n

<\/h3>\n

\t\t\u9526\u5b89 \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:15
\u4f2a\u4ee3\u7801:<\/p>\n

\u8bfb\u53d6excel \u83b7\u53d6list< softwriter , yunfile >list<\/p>\n

\u597d\u6ef4\uff0c\u8c22\u8c22\u5927\u4f6c\uff0c\u6211\u7814\u7a76\u7814\u7a76\uff0c\u518d\u767e\u5ea6\u4e00\u4e0b\t\t\t\t<\/p>\n

\t\t\t\t\tq959954596<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2019-12-10 15:18:08\t<\/p>\n

<\/h3>\n

\t\t\u8981\u7528php\u6216\u8005java\u8bfb\u53d6excel\uff0c\u5faa\u73af\u6267\u884csql\uff0c\u53ea\u9760sql\u547d\u4ee4\u4f30\u8ba1\u4e0d\u884c\t\t\t <\/p>\n","protected":false},"excerpt":{"rendered":"

bob1987 \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/40165"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=40165"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/40165\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=40165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=40165"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=40165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}