MySQL 从一张表update字段到另外一张表中

一、UPDATE
UPDATE 表1 AS 别名1
INNER JOIN 表2 AS 别名2
ON 别名1.字段 = 别名2.字段 AND 其他条件
SET 别名1.字段1 = 别名2.字段1,…,别名1.字段n = 别名2.字段n;

UPDATE ac_prefixesv4 AS A 
LEFT JOIN ac_asnumber AS B ON A.asfk = B.id
LEFT JOIN ac_country AS C ON B.cc = C.id
SET A.countryid = C.id,A.countrycode = C.`name`

二、DELETE
DELETE 别名1,别名2
FROM 表1 AS 别名1
INNER JOIN 表2 AS 别名2
ON 别名1.字段 = 别名2.字段 AND 其他条件;
 

DELETE S FROM spawnlist AS S
INNER JOIN npc AS N ON S.npc_templateid = N.idTemplate
WHERE (N.type = "monster");