21,881
社区成员
发帖
与我相关
我的任务
分享
update games set games.status = 2 inner join gameapplyways
on games.id = gameapplyways.game_id
where gameapplyways.apply_deadline < curdate()
and games.status = 7 and games.id = 6
update games, gameapplyways set games.status = 2 where gameapplyways.apply_deadline < curdate() and games.status = 7 and games.id = 6 and games.id = gameapplyways.game_id