sql server 语法转mysql 语法

各位牛爷爷,帮忙看下这个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

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

update 更新语句不需要转就能用呀，执行有什么问题么？

牛爷爷不知道,但是王叔叔知道, 发一下你的报错信息