mysql中 将一张表的数据内容update至另外一张表:
UPDATE targettable a INNER JOIN
(SELECT DISTINCT mfp.materialCode,mfp.materialFlowNo FROM targettablem,test mfp WHERE m.materialFlowNo=mfp.materialFlowNo) m2
ON m2.materialFlowNo=a.materialFlowNo AND a.materialCode IS NULL
SET a.materialCode=m2.materialCode;
targettable为要修改的表,将要修改的数据查询出来放在m2中和主表进行关联,然后set要修改的字段就可以了;