mysql(update)

1.更新数据来自子表字段，且带where条件；

update a set a.i = (select b.i from b where a.ii = b.ii) where a.h = ‘’；

a.ii = b.ii,能确定更新的是哪条，或者什么数据；

2.更新字段，即查询关联字段；（不能做此更改）

update a set a.i = (select b.i from b where a.i = b.i) where a.h = ‘’；(错误)

正确：

update stc inner join (select biz_code,user_id from bta where bta.user_id = ‘’) a on a.user_id = stc.user_id set stc.user_id = a.biz_code;