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

摘要： @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 阅读全文