sql:建表,插入,查询语句
来源:互联网 发布:网络问卷调查的过程 编辑:程序博客网 时间:2024/05/01 21:26
建表
CREATE TABLE IF NOT EXISTS `player` (
`userID` int(10) NOT NULL COMMENT '用户ID',
`createAreaID` int(10) NOT NULL COMMENT '创建区ID',
`playerID` int(10) NOT NULL COMMENT '角色ID',
`uid` varchar(30) NOT NULL COMMENT '平台账号ID',
`platform` varchar(30) NOT NULL COMMENT '平台',
`name` varchar(20) NOT NULL COMMENT '名字',
`loginData` blob NOT NULL COMMENT '登陆数据',
`data` blob NOT NULL COMMENT '主数据',
PRIMARY KEY (`playerID`),
KEY `name` (`name`),
KEY `userID` (`userID`),
KEY `createAreaID` (`createAreaID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';
角色登陆表
DROP TABLE IF EXISTS `PlayerLogin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `PlayerLogin` (
`iEventId` bigint(20) DEFAULT NULL,
`dtEventTime` datetime DEFAULT NULL,
`iOpenId` varchar(128) DEFAULT NULL,
`iPId` varchar(128) DEFAULT NULL,
`iClientIp` varchar(48) DEFAULT NULL,
`iWorldId` varchar(20) DEFAULT NULL,
`iDid` varchar(128) DEFAULT NULL,
`iShareId` varchar(128) DEFAULT NULL,
`iLoginState` varchar(10) DEFAULT NULL,
KEY `PlayerLogin_iDid` (`iDid`),
KEY `PlayerLogin_iOpenId` (`iOpenId`),
KEY `PlayerLogin_dtEventTime` (`dtEventTime`),
KEY `PlayerLogin_iPId` (`iPId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
创建角色表
DROP TABLE IF EXISTS `CreatePlayer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CreatePlayer` (
`iEventId` bigint(20) DEFAULT NULL,
`dtEventTime` datetime DEFAULT NULL,
`iOpenId` varchar(128) DEFAULT NULL,
`iPId` varchar(48) DEFAULT NULL,
`iClientIp` varchar(48) DEFAULT NULL,
`iWorldId` varchar(20) DEFAULT NULL,
`iDid` varchar(128) DEFAULT NULL,
`iShareId` varchar(128) DEFAULT NULL,
`iLoginState` varchar(10) DEFAULT NULL,
KEY `CreatePlayer_iOpenId` (`iOpenId`),
KEY `CreatePlayer_iPId` (`iPId`),
KEY `CreatePlayer_iDid` (`iDid`),
KEY `CreatePlayer_dtEventTime` (`dtEventTime`),
KEY `PlayerLogin_iWorldId` (`iWorldId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
插入数据语句
OCK TABLES `CreatePlayer` WRITE;
/*!40000 ALTER TABLE `CreatePlayer` DISABLE KEYS */;
INSERT INTO `CreatePlayer` VALUES (1489564431386,'2017-03-15 03:53:51','','guest_android','116.104.101.113','2','24a87cd8757ae1dcfb1922c02a5ee48d','2a6fe936-2edc-46c4-a0b6-5743489095f3','0')
/*!40000 ALTER TABLE `CreatePlayer` ENABLE KEYS */;
UNLOCK TABLES;
查询
select count(distinct iDid) as didNum from PlayerLogin
where dtEventTime>="2017-06-06 00:00:00.0" and dtEventTime <"2017-06-07 00:00:00.0"
and iDid in (select distinct iDid from CreatePlayer
where dtEventTime >="2017-06-01 13:00:00.0" and dtEventTime< "2017-06-02 00:00:00.0");
- sql:建表,插入,查询语句
- Oracle:插入模板查询SQL语句
- sql 先查询,再插入语句
- PL/SQL developer快速生成插入语句和查询语句
- C#下使用sql语句查询,插入,更新,删除
- sql语句使用-插入列与连接查询
- SQL语句插入变量
- 优化SQL插入语句
- SQL更新插入语句
- SQL-插入语句中的‘,”,{
- 1.SQL建表、插入、查询数据
- sql 查询插入
- SQL插入查询
- sql 查询插入
- 查询Oracle最近插入语句
- sql查询语句--连接语句
- SQL查询语句基础
- 通用SQL查询语句
- 算法竞赛入门经典 UVa1586
- Lua基础
- Linux python 与pip升级与问题解决
- Safecracker
- css基础知识
- sql:建表,插入,查询语句
- 转载:做正确的事情,等着被开除(Do the right thing, Wait to get fired)
- Xshell 使用技巧
- Sweet Snippet系列之 Print Lua Table
- 赋值运算符
- C4
- 使用位运算,处理数据库中的"多选状态标识"
- Java程序语言
- 欢迎使用CSDN-markdown编辑器