连锁数据整理

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_chainmemberlevel where 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');