常用SQL语句<1>

封号/解封

update MEMB_INFO set bloc_code = 1 where memb___id='帐号'   ===>>> 大于0 封号  =0 解封

创建账号

insert into dbo.MEMB_INFO(memb___id, memb__pwd,memb_name,sno__numb,bloc_code,ctl1_code)  values(账号, 密码,'Name','随机',0,0);  建号

N天未登录账号查询

SELECT DATEDIFF(day, DisConnectTM, GETDATE()) AS days_diff  
FROM MEMB_STAT;

角色人物加属性点

update Character set Energy=32000 where Name ='角色名'  加点

攻城日志清理

USE [MuOnline]
truncate TABLE MuCastle_DATA