sqlserver与mysql连表修改数据

sqlserver:

update S set S.ClassName=C.Name from Student S, Class C where S.C_ID=C.ID

mysql:
update Student S,Class C set S.ClassName=C.Name where S.C_ID=C.ID
update Student S inner join Class C on S.C_ID=C.ID set S.ClassName=C.Name