批量列新SQL

2023-03-06 10:08:44 阅读:1 编辑
UPDATE ims_zhyshop_sun_user as u
INNER JOIN ims_zhyshop_sun_pusher as p ON p.user_id = u.id
SET u.wugu_empty_last_time=1679500800
WHERE p.level=1
  AND u.wugu_empty_last_time=0