sql server 语法转mysql 语法

Question

各位牛爷爷,帮忙看下这个sql语句,sqlserver转mysql
update ChangeOrderUpdateStatis set totalBookKid = p.kid, totalBook = p.tname, totalSortOrder = p.sortOrder
from Sort s left Join sort p on p.kid as = s.parentId and p.nodeType = 2
where ChangeOrderUpdateStatis.partBookKid is not null and ChangeOrderUpdateStatis.totalBookKid is null
and s.kid = ChangeOrderUpdateStatis.partBookKid

Answer 1

update ChangeOrderUpdateStatis cous 
left join Sort s 
on cous.partBookKid = s.kid 
left Join sort p 
on p.kid as = s.parentId 
and p.nodeType = 2
set totalBookKid = p.kid, totalBook = p.tname, totalSortOrder = p.sortOrder
where cous.partBookKid is not null 
and cous.totalBookKid is null