C#第十二章 项目案例：QQ数据库管理

QQ数据库管理

--用户表
  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'
  
  SELECT *from dbo.QQUser
  
  --基本信息表
  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
  
  --关系表
  INSERT dbo.Relation(QQID,RelationQQID,RelationStatus)
  SELECT '54789625',