UPDATE sl_shop s1 INNER JOIN (SELECT id FROM sl_shop WHERE is_stop is NULL) s2 SET is_stop=1 WHERE s1.id =s2.id
updateById:mysql修改根据筛选过滤出来的id数据
最新推荐文章于 2024-06-18 15:46:51 发布
UPDATE sl_shop s1 INNER JOIN (SELECT id FROM sl_shop WHERE is_stop is NULL) s2 SET is_stop=1 WHERE s1.id =s2.id