摘要： 1.update mem_memberaccount set level=4 where id in (select id from (select a.id,a.uniqueid,a.levelname,b.level from mem_memberbaseinfo a,mem_memberaccount b where a.id=b.id) x where level='5' and levelname'vip');2.update mem_memberbaseinfo set levelname=(select name from mem_chainmem 阅读全文