UPDATE tn ,(SELECT xx,,GROUP_CONCAT(ID) id FROM tb GROUP BY xID) ta SET tn.xxx=id WHERE ta.xx=tn.xx ; 多数据到一字段