Question

sql 语句为什么执行效果不对

update job_member set member_activedate=date() where member_id in (select top 10 member_id from job_member where datediff('d',member_activedate,date())>1 order by member_activedate,member_id)

我用这样的语句，提把10条记录，按更新日期提交，然后刷 新更新日期。执行时提示影响了10记录，但我在前台查看结果时只有1条记录被更新。

Answer 1

直接去数据库查看，是否是10条记录被更新了？？

Answer 2

大哥 你也得让我知道是什么不对啊

Answer 3

直接去数据库查看

Answer 4

分开做select top 10 member_id into #temp from job_member where datediff('d',member_activedate,date())>1 order by member_activedate,member_id
update job_member set member_activedate=date() where member_id in (select member_id from #temp)