摘要：UPDATE a,bSET ps=if(ps='0','1',ps),uptime=if(ps='0',acttime,uptime),pw=if(ps='0','123',pw)where eo_on in(select id fromb where status ='1') and a.on=b.id 阅读全文