13 修改数据

USE QQMaster--今天我隐身登录，假设我的QQ号码为8855678。UPDATE QQUser SET OnLine=2,LastLogTime=GETDATE() WHERE QQID=8855678--假设我的QQ号码为8855678，修改我的昵称为“被淹死的鱼”，地址为“解放中路6号院106室”。UPDATE BaseInfo SET NickName='被淹死的鱼',Address='解放中路6号院106室' WHERE QQID=8855678--假设我的QQ号码为8855678，将我的好友“248624066”拖进黑名单。UPDATE Relation SET RelationStatus=1 WHERE QQID=8855678 AND RelationQQID=248624066--为了提高QQ用户的聊天积极性，把等级小于6级的用户的等级都提升1个级别。UPDATE QQUser SET Level=level+1 WHERE level<=5 --管理员将超过365天没有登录过的QQ锁定（即将等级值设定为-1）。UPDATE QQUser SET Level=-1 WHERE DATEDIFF(DAY,lastLogTime,GETDATE())>=365--为了奖励用户，将好友数量超过20的用户等级提升1个级别。UPDATE QQUser SET Level=level+1 WHERE QQID IN(SELECT QQID  FROM Relation  WHERE RelationStatus=0 GROUP BY QQID HAVING COUNT(*)>=20)--把QQ号码为286314的用户的好友“嘟嘟鱼”拖进黑名单中。UPDATE Relation SET RelationStatus=1WHERE QQID=286314 AND RelationQQID IN(SELECT QQID FROM BaseInfo WHERE NickName='嘟嘟鱼')AND  RelationStatus=0