最近项目中碰到的

成功:

update user_shop t3 , (select distinct(t1.id) from user_shop t1,commn_pic t2 where t1.shop_id=t2.SJ_ID and t1.form_id=t2.form_id and zone-371600 between 0 and 100 order by t1.id) t4 set t3.user_set = 'detailInfo,picture0' where
t3.id=t4.id

 

语法错误：

update user_shop set USER_SET='detailInfo'  WHERE  id in(596,597,598)
(select id from user_shop where zone-371600 between 0 and 100 and
  id not in (select t1.id from user_shop t1,commn_pic t2 where t1.shop_id=t2.SJ_ID and t1.form_id=t2.form_id and zone-371600 between 0 and 100) )