摘要： 我一开始使用的Sql：update cms_product_provider_properties set value = '广东' where attribute_id in (select id from cms_provider_properties_view b ON a.attribute_id = b.id where b.name ='产地' and (b.value is null or b.value = ''))这种方法不行之后使用：update cms_product_provider_properties set valu 阅读全文