正确语句
1
update jytuser
set userid
=(
select member.userid
from member
where member.id
=jytuser.owner_id)
有2个易错点:
1)表自关联好像行不通。我猜想会不会和查询时建立的索引更改有关。
2)这种写法postgres不支持
1
update jytuser,member
set jytuser.userid
=member.userid
where jytuser.owner_id
=jmember.id
and jytuser.userid
=
0;
报错如下: