VIP会员
购物车
私信
发表新帖
立即签到sql 将qq好友数量超过20的用户等级提升1个级别
发表在Oracle视频答疑
2013-12-08
是否精华
是
否
版块置顶:
是
否
update QQuser set Level=Level+1
where QQID in(select COUNT(*), QQID 用户 from Relation
where Relationstatus=0
group by QQID
having COUNT(*)>=20)
不对写成
update QQuser set Level=Level+1
where QQID in(select QQID 用户 from Relation
where Relationstatus=0
group by QQID
having COUNT(*)>=20)
√了why
where QQID in(select COUNT(*), QQID 用户 from Relation
where Relationstatus=0
group by QQID
having COUNT(*)>=20)
不对写成
update QQuser set Level=Level+1
where QQID in(select QQID 用户 from Relation
where Relationstatus=0
group by QQID
having COUNT(*)>=20)
√了why
分享到：
关注
回复
支持(
反对(
