56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT Sum(ul.money) as total FROM userlog AS ul left Join tz AS tz ON ul.tzid = tz.id WHERE
ul.uid in(4213,4215,4216,4218,4219,4224,4226,4232,4235,4248,4251,4255,4262,4268,4308,4354)
AND tz.zt < 4 and ( ul.logtype ='tzfd' or ul.logtype = 'zhfd' or ul.logtype = 'dlfd' ) and
( ul.logtime >='1369074600' and ul.logtime <= '1369161000' )
CREATE TABLE `userlog` (
`id` int(11) NOT NULL AUTO_INCREMENT ,
`idchar` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '随机编号' ,
`fid` int(11) NULL DEFAULT NULL COMMENT '0' ,
`uid` int(11) NULL DEFAULT NULL ,
`tzid` int(11) NULL DEFAULT NULL ,
`czlx` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`logtype` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`money` double(20,6) UNSIGNED NULL DEFAULT 0.000000 ,
`oldmoney` double(20,6) UNSIGNED NOT NULL ,
`logtime` int(11) NULL DEFAULT NULL ,
`logip` char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
INDEX `uid` (`uid`) USING BTREE ,
INDEX `tzid` (`tzid`) USING BTREE ,
INDEX `czlx` (`czlx`) USING BTREE ,
INDEX `logtype` (`logtype`) USING BTREE ,
INDEX `money` (`money`) USING BTREE ,
INDEX `logtype_2` (`logtype`) USING BTREE
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='tz=tz'
AUTO_INCREMENT=1
ROW_FORMAT=COMPACT;
我要返回根据传入的UID和时间,返回money的总和.
我这样写应该可以明白了点吧