sqlserver/mysql数据库批量更新

sqlserver数据库批量更新
UPDATE a SET WtNo=b.NO
from WT_Task a
INNER JOIN WT_BasicInformation b ON a.WtId=b.ID;



mysql数据库批量更新
UPDATE student s JOIN class c ON s.class_id = c.id SET s.class_name='test11',c.stu_name='test11'