摘要: 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. 阅读全文
posted @ 2012-05-25 21:47 cheng1234xiang 阅读(375) 评论(0) 推荐(0) 编辑