SQL QQ数据库管理 QQMaster
用户表User
INSERT dbo.QQUser(QQID,PassWord,LastLogTime,Online,Level)
SELECT '54789625','add512#&','2013-02-16 17:01:35','2','1' UNION
SELECT '88662753','admin0219','2013-02-19 21:08:50','0','5'UNION
SELECT '8855678','guest0221','2013-02-21 16:28:20','1','6'
基本信息表Baselnfo
INSERT dbo.Baselnfo(QQID,NickName,Sex,Age,Province,City,Address,Phone)
SELECT '54789625','蝴蝶飞飞','1','16','北京市','北京','亚运村','37547388157668'UNION
SELECT '88662753','秋芙蓉','0','20','河南省','南阳','方成博望','88715783657725'UNION
SELECT '8855678','双眼皮の猪','1','38','北京市','北京','双榆树东里','65794968876143'
SELECT *from dbo.Baselnfo
关系表Relation
INSERT dbo.Relation(QQID,RelationQQID,RelationStatus)
SELECT '54789625','88662753','0'UNION
SELECT '88662753','8855678','1'