正确的：
update product_product ouset default_pre = ou.default_pre || 'A'from ( select default_pre from product_product group by default_pre having count(*) > 1 ) inrwhere not ou.active and ou.default_pre = inr.default_pre
正确的：
update product_product ouset default_pre = ou.default_pre || 'A'from ( select default_pre from product_product group by default_pre having count(*) > 1 ) inrwhere not ou.active and ou.default_pre = inr.default_pre
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
