摘要:
update U set UserID=US.UserIDfrom UserExtendInfos as U ,Users as USwhere U.FullName=US.LoginNamemysql update from 子查询mssql 子查询更新update log set uin= b.uinfrom log a,logs bwhere a.accountuin = b.accountuinmysql 不支持 update 子查询更新找了半天资料 终于搞定了...update `log` a inner join `logs` b on a.`accountuin` = b.`a. 阅读全文