想将cwd_user表directory_id=1 的user_name更新成directory_id=10001的名称,哪位指导下
楼主好,参考
update cwd_user b
inner join
(select * from cwd_user b where b.directory_id=10001 ) a
on a.colname=b.colname --(找个唯一字段能关联的)
set b.user_name=a.user_name where b.directory_id=1
Update cwd_user set user_name=(select user_name from cwd_user where directory_id='10001') where directory_id='1'
不建议多一步的话,你可以先找出directory_id=10001对应的user_name 的名字(得只有一个值),然后用update cwd_user set user_name=‘刚刚找出的名字’ from cwd_user where directory_id=1