12 2013 档案

update mem_memberaccount
摘要：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'); 阅读全文

posted @ 2013-12-25 16:58 awk 阅读(168) 评论(0) 推荐(0)

MergeData
摘要：@echo offtitle PubwinTool By 76449628color 0Aif not exist "%java_home%\bin\java.exe" goto end2:firclsecho use local >test.sqlecho go >test.sqlset /p pwd="请输入数据库访问密码:"OSQL /S localhost /U netcafe /P %userpwd% /i test.sqlIF ERRORLEVEL 1 goto end1del /f /q test.sqlclsosql -U n 阅读全文

posted @ 2013-12-25 16:55 awk 阅读(332) 评论(0) 推荐(0)

连锁数据整理
摘要：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 阅读全文

posted @ 2013-12-04 18:57 awk 阅读(142) 评论(0) 推荐(0)

导航