我有这样的表:idIPSubnetDuplicatesValid1foo1612bar2413foo2814foo321我想用重复行的id更新描述。像这样的东西:idIPSubnetDuplicatesValid1foo163,402bar2413foo281,404foo321,30这是我的查询:updatetblSampleinnerjoin(selectt1.Id,group_concat(t2.Id)dupsfromtblSamplet1innerjointblSamplet2ont1.Idt2.Id)AND((t1.IP>>(32-LEAST(t1.Subnet,t2.Sub