UPDATE table_name as a
INNER JOIN DoNotCallList b
ON (a.tmpphone=b.PhoneNo)
SET a.donotcall=b.status,a.DateOfLastDNCLScrub=b.DateCreated;
大数据量联合查询时,需要把tmpphone,PhoneNo两个字段分别加索引,提高效率。
UPDATE table_name as a
INNER JOIN DoNotCallList b
ON (a.tmpphone=b.PhoneNo)
SET a.donotcall=b.status,a.DateOfLastDNCLScrub=b.DateCreated;
大数据量联合查询时,需要把tmpphone,PhoneNo两个字段分别加索引,提高效率。