尝试这个：
UPDATe data_table t, (SELECT DISTINCT ID, NAME, VALUE FROM data_table WHERe VALUE IS NOT NULL AND VALUE != '') t1 SET t.VALUE = t1.VALUE WHERe t.ID = t1.ID AND t.NAME = t1.NAME
尝试这个：
UPDATe data_table t, (SELECT DISTINCT ID, NAME, VALUE FROM data_table WHERe VALUE IS NOT NULL AND VALUE != '') t1 SET t.VALUE = t1.VALUE WHERe t.ID = t1.ID AND t.NAME = t1.NAME
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
