17,089
社区成员
发帖
与我相关
我的任务
分享
-- 1. 检查表结构
desc question;
desc restore;
-- 2. 更新数据
update question q set q.state = 0
where exists (
select count(distinct(userid))
from restore
where quid = q.id
having count(distinct(userid)) > 10
)
-- 你执行以下语句,把结果贴出来看看:
desc question;
-- 要不这样试试:
update question qu set qu.state=0
where exists ( select count(distinct(re.userid))
from resotre re
where re.quid=qu.id
having count(distinct(re.userid)) > 10 );
-- 要不这样试试:
update question qu set qu.state=0
where exists ( select count(distinct(re.userid))
from resotre re
where re.quid=qu.id
having countdistinct(re.userid)) > 10 );