常用sql语句 

update zt_soa_users_origin  set processed=0  where  pri_key in(
select pri_key from zt_soa_users_origin zsuo  where processed = -1 and import_date >'2020-09-30 03:09:41')

 

posted @ 2020-10-14 15:44  huanglei2010  阅读(81)  评论(0)  编辑  收藏  举报