mysql 存qq数据_MySQL---QQ数据库
insert into BaseInfo
select 54789625,蝴蝶飞飞,1,16,北京市,北京,亚运村,37543881566union
select 88662753,秋芙蓉,0,20,河南省,南阳,方城博望,88715783657union
select 8855678,双眼,1,38,北京市,北京,双榆树东村,65794968876
values(54789625,123456,2013-02-16 17:01:35,2,1),
(88662753,130219,2013-02-19 21:08:50,0,5),
(8855678,130221,2013-02-21 16:28:20,1,6)
FROM BaseInfo
FROM Relation,BaseInfo
SELECT *
FROM Relation
--查询被当做黑名单人物次数排名前20的用户
FROM Relation
WHERE RelationStatus=1
--修改用户的个人信息
update dbo.BaseInfo
set NickName=青青,Address=峪里村
--修改限定条件关系用户的信息
update Relation
--修改管理方面的信息
set Level=(Level+1)
WHERE Level<6
--删除黑名单中的用户
DELETE Relation
set Level=-1
WHERE DATEDIFF(dd,LastLogTime,GETDATE())>1000 and Online=1
insert into BaseInfo select 54789625,蝴蝶飞飞,1,16,北京市,北京,亚运村,37543881566union select 88662753,秋芙蓉,0,20,河南省,南阳,方城博望,88715783657union select 8855678,双眼,1,38,北京市,北京,双榆树东村,65794968876 values(54789625,123456,2013-02-16 17:01:35,2,1), (88662753,130219,2013-02-19 21:08:50,0,5), (8855678,130221,2013-02-21 16:28:20,1,6) FROM BaseInfo FROM Relation,BaseInfo SELECT * FROM Relation --查询被当做黑名单人物次数排名前20的用户 FROM Relation WHERE RelationStatus=1 --修改用户的个人信息 update dbo.BaseInfo set NickName=青青,Address=峪里村 --修改限定条件关系用户的信息 update Relation --修改管理方面的信息 set Level=(Level+1) WHERE Level<6 --删除黑名单中的用户 DELETE Relation set Level=-1 WHERE DATEDIFF(dd,LastLogTime,GETDATE())>1000 and Online=1