{"id":199382,"date":"2025-05-03T11:08:37","date_gmt":"2025-05-03T03:08:37","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199382\/"},"modified":"2025-05-03T11:08:37","modified_gmt":"2025-05-03T03:08:37","slug":"%e5%8e%bb%e9%99%a4ecshop%e5%95%86%e5%93%81%e9%87%8d%e5%a4%8d%e5%b1%9e%e6%80%a7sql%e5%91%bd%e4%bb%a4","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199382\/","title":{"rendered":"\u53bb\u9664ecshop\u5546\u54c1\u91cd\u590d\u5c5e\u6027sql\u547d\u4ee4"},"content":{"rendered":"<p>\u91c7\u7528ecshop\u52a9\u7406\u4ee5\u53ca\u540e\u53f0\u6279\u91cf\u5bfc\u5165\u529f\u80fd\uff0c\u5f88\u5bb9\u6613\u5f15\u8d77\u5546\u54c1\u5c5e\u6027\u503c\u6df7\u4e71\uff0c\u5982\u679c\u5c5e\u6027\u503c\u91cd\uff0c\u4ee5\u4e0b\u65b9\u6cd5\u53ef\u4ee5\u5f88\u597d\u7684\u89e3\u51b3\u503c\u552f\u4e00\u95ee\u9898<br \/>\n<br \/> <br \/>\n<img decoding=\"async\" src=\"https:\/\/www.ldhost.cn\/helphmb\/uploads\/allimg\/150314\/1-150314140F95V.png\" style=\"width: 165px;height: 39px\" class=\"aligncenter\"><br \/>\n<br \/> \u5728\u6570\u636e\u5e93\u4e2d\u6267\u884c\u4ee5\u4e0b\u8bed\u53e5\uff1a   &nbsp;   delete a &nbsp;   from `ecs_goods_attr` a &nbsp;&nbsp;   left join(select `goods_attr_id`,`attr_id` from `ecs_goods_attr` group by goods_id,attr_value) b &nbsp;   on a.`goods_attr_id` = b.`goods_attr_id` &nbsp;   and a.`attr_id` = b.`attr_id` &nbsp;   where b.`goods_attr_id` is null AND b.`attr_id` is null; &nbsp;   &nbsp;  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u91c7\u7528ecshop\u52a9\u7406\u4ee5\u53ca\u540e\u53f0\u6279\u91cf&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4925],"tags":[],"class_list":["post-199382","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/comments?post=199382"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199382\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}