UPDATE a SET a.parentnodeid = b.id from temptable20110415t09373513028314548821 a join nodes_hierarchy b on a.`name`=b.`name` and a.`level`=F_GetNodeLevel(b.id)
UPDATE a from temptable20110415t09373513028314548821 a join nodes_hierarchy b on a.`name`=b.`name` and a.`level`=F_GetNodeLevel(b.id) SET a.parentnodeid = b.id
UPDATE `temptable20110415t09373513028314548821` a INNER JOIN nodes_hierarchy b ON a.`name`=b.`name` AND a.`level`=F_GetNodeLevel(b.id) SET a.parentnodeid = b.id
你这是sqlserver的写法 mysqlUPDATE temptable20110415t09373513028314548821 a, nodes_hierarchy b SET a.parentnodeid = b.id where a.name=b.name and a.level=F_GetNodeLevel(b.id)
from temptable20110415t09373513028314548821 a join nodes_hierarchy b
on a.`name`=b.`name` and a.`level`=F_GetNodeLevel(b.id) SET a.parentnodeid = b.id
ON a.`name`=b.`name` AND a.`level`=F_GetNodeLevel(b.id)
SET a.parentnodeid = b.id
mysqlUPDATE temptable20110415t09373513028314548821 a, nodes_hierarchy b
SET a.parentnodeid = b.id
where a.name=b.name and a.level=F_GetNodeLevel(b.id)