mysql 查询出来ID作为条件更新

update v5_user  set is_invite = 1 where id in ( select temp.to_uid from ( select to_uid from v5_invite_user where 1 ) temp )
posted @ 2022-11-17 09:41  Abner3721  阅读(195)  评论(0编辑  收藏  举报