34,587
社区成员
发帖
与我相关
我的任务
分享
update mission_book a
inner join mission_item b
on a.col=b.col
set a.mission_status=2
where a.col=xxx
update a set a.mission_status=2 from mission_book a inner join mission_item b on a.13 = b.13 where a.player_id=$user_id and a.mission_id=$mission_id
update mission_book a
inner join mission_item b
on 13=13
set a.mission_status=2