56,940
社区成员




select
*
from
tbAnalog_20140919175031_A
where
deviceid = 5355
and CreatedDateTime >= '2014-01-08 00:00:00' and CreatedDateTime <= '2014-01-09 00:00:00'
CREATE TABLE `tbAnalog_20140919175031_A` (
`Id` bigint(20) NOT NULL AUTO_INCREMENT,
`CreatedDateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`UserId` int(11) NOT NULL,
`DeviceId` int(11) NOT NULL,
`Col_000` smallint(6) DEFAULT NULL,
`Col_001` smallint(6) DEFAULT NULL,
`Col_002` smallint(6) DEFAULT NULL,
`Col_003` float(9,1) DEFAULT NULL,
`Col_004` float(9,1) DEFAULT NULL,
`Col_005` float(9,1) DEFAULT NULL,
`Col_006` smallint(6) DEFAULT NULL,
`Col_007` smallint(6) DEFAULT NULL,
`Col_008` smallint(6) DEFAULT NULL,
`Col_009` float(9,1) DEFAULT NULL,
`Col_010` float(9,1) DEFAULT NULL,
`Col_011` float(9,1) DEFAULT NULL,
`Col_012` float(9,1) DEFAULT NULL,
`Col_013` smallint(6) DEFAULT NULL,
`Col_014` float(9,1) DEFAULT NULL,
`Col_015` float(9,1) DEFAULT NULL,
`Col_016` float(9,1) DEFAULT NULL,
`Col_017` smallint(6) DEFAULT NULL,
`Col_018` smallint(6) DEFAULT NULL,
`Col_019` smallint(6) DEFAULT NULL,
`Col_020` smallint(6) DEFAULT NULL,
`Col_021` smallint(6) DEFAULT NULL,
`Col_022` float(9,1) DEFAULT NULL,
`Col_023` double(18,1) DEFAULT NULL,
`Col_024` float(18,3) DEFAULT NULL,
`Col_025` float(9,1) DEFAULT NULL,
PRIMARY KEY (`Id`,`CreatedDateTime`),
KEY `idx_A_20140919175041_CDT` (`CreatedDateTime`),
KEY `idx_A_20140919175041_UId` (`UserId`),
KEY `idx_A_20140919175041_DId` (`DeviceId`)
) ENGINE=InnoDB AUTO_INCREMENT=331831721 DEFAULT CHARSET=utf8
/*!50100 PARTITION BY RANGE (Year(`CreatedDateTime`)*10000 + Month(`CreatedDateTime`)*100 + Day(`CreatedDateTime`))
(PARTITION pl20140110 VALUES LESS THAN (20140110) ENGINE = InnoDB,
PARTITION pl20140120 VALUES LESS THAN (20140120) ENGINE = InnoDB,
PARTITION pl20140130 VALUES LESS THAN (20140130) ENGINE = InnoDB,
PARTITION pl20140210 VALUES LESS THAN (20140210) ENGINE = InnoDB,
PARTITION pl20140220 VALUES LESS THAN (20140220) ENGINE = InnoDB,
PARTITION pl20140230 VALUES LESS THAN (20140230) ENGINE = InnoDB,
PARTITION pl20140310 VALUES LESS THAN (20140310) ENGINE = InnoDB,
PARTITION pl20140320 VALUES LESS THAN (20140320) ENGINE = InnoDB,
PARTITION pl20140330 VALUES LESS THAN (20140330) ENGINE = InnoDB,
PARTITION pl20140410 VALUES LESS THAN (20140410) ENGINE = InnoDB,
PARTITION pl20140420 VALUES LESS THAN (20140420) ENGINE = InnoDB,
PARTITION pl20140430 VALUES LESS THAN (20140430) ENGINE = InnoDB,
PARTITION pl20140510 VALUES LESS THAN (20140510) ENGINE = InnoDB,
PARTITION pl20140520 VALUES LESS THAN (20140520) ENGINE = InnoDB,
PARTITION pl20140530 VALUES LESS THAN (20140530) ENGINE = InnoDB,
PARTITION pl20140610 VALUES LESS THAN (20140610) ENGINE = InnoDB,
PARTITION pl20140620 VALUES LESS THAN (20140620) ENGINE = InnoDB,
PARTITION pl20140630 VALUES LESS THAN (20140630) ENGINE = InnoDB,
PARTITION pl20140710 VALUES LESS THAN (20140710) ENGINE = InnoDB,
PARTITION pl20140720 VALUES LESS THAN (20140720) ENGINE = InnoDB,
PARTITION pl20140730 VALUES LESS THAN (20140730) ENGINE = InnoDB,
PARTITION pl20140810 VALUES LESS THAN (20140810) ENGINE = InnoDB,
PARTITION pl20140820 VALUES LESS THAN (20140820) ENGINE = InnoDB,
PARTITION pl20140830 VALUES LESS THAN (20140830) ENGINE = InnoDB,
PARTITION pl20140910 VALUES LESS THAN (20140910) ENGINE = InnoDB,
PARTITION pl20140920 VALUES LESS THAN (20140920) ENGINE = InnoDB,
PARTITION pl20140930 VALUES LESS THAN (20140930) ENGINE = InnoDB,
PARTITION pl20141010 VALUES LESS THAN (20141010) ENGINE = InnoDB,
PARTITION pl20141020 VALUES LESS THAN (20141020) ENGINE = InnoDB,
PARTITION pl20141030 VALUES LESS THAN (20141030) ENGINE = InnoDB,
PARTITION pl20141110 VALUES LESS THAN (20141110) ENGINE = InnoDB,
PARTITION pl20141120 VALUES LESS THAN (20141120) ENGINE = InnoDB,
PARTITION pl20141130 VALUES LESS THAN (20141130) ENGINE = InnoDB,
PARTITION pl20141210 VALUES LESS THAN (20141210) ENGINE = InnoDB,
PARTITION pl20141220 VALUES LESS THAN (20141220) ENGINE = InnoDB,
PARTITION pl20141230 VALUES LESS THAN (20141230) ENGINE = InnoDB,
PARTITION pl20150110 VALUES LESS THAN (20150110) ENGINE = InnoDB,
PARTITION pl20150120 VALUES LESS THAN (20150120) ENGINE = InnoDB,
PARTITION pl20150130 VALUES LESS THAN (20150130) ENGINE = InnoDB,
PARTITION pl20150210 VALUES LESS THAN (20150210) ENGINE = InnoDB,
PARTITION pl20150220 VALUES LESS THAN (20150220) ENGINE = InnoDB,
PARTITION pl20150230 VALUES LESS THAN (20150230) ENGINE = InnoDB,
PARTITION pl20150310 VALUES LESS THAN (20150310) ENGINE = InnoDB,
PARTITION pl20150320 VALUES LESS THAN (20150320) ENGINE = InnoDB,
PARTITION pl20150330 VALUES LESS THAN (20150330) ENGINE = InnoDB) */;