update user_score set score=(score+5)
where acc_nbr in (select calling_nbr from tb_up50_call where calling_nbr!=called_nbr
group by calling_nbr);是score=(score+5)计算,和acc_nbr in还有group by 的问题么?
谢谢解答!
where acc_nbr in (select calling_nbr from tb_up50_call where calling_nbr!=called_nbr
group by calling_nbr);是score=(score+5)计算,和acc_nbr in还有group by 的问题么?
谢谢解答!
tb_up50_call:calling_nbr上建立索引没有
当然这的group by可以换成Distinct试试
set score=(score+5)
where acc_nbr=calling_nbr
update user_score set score=(score+5)
where acc_nbr exists (select calling_nbr from tb_up50_call where calling_nbr!=called_nbr
group by calling_nbr);
上面引用错了
update user_score set score=(score+5)
where exists (select calling_nbr from tb_up50_call where calling_nbr!=called_nbr
acc_nbr=calling_nbr);