数据库里的表(从11.1号开始看) 是每两天上传一次到表里。 我现在要做汇总。 就是把同一天的数据相加,最后根据选择日期范围选择出来。 应该怎么写 下图是数据库截图下图是效果图,日期可以不要。下图不是上图的关联数据,只是提供效果。
解决方案 »
- MySQL主从同步问题
- 如何将c#的image存储为postgreSQL的bit类型
- 求高难度SQL语句,删除重复字段中高/低值记录
- Win下面的MySql数据库和Linux下的MySql数据库能不能通用?
- 求助:装了MSSQL后MYSQL无法启动?
- mysql导入数据的编码问题
- 如何将命令结果集写入到表中
- 大家好,程序写完,需要把数据库与程序从win移到lunix下使用,请问mysql的数据库如何移过去?
- mysql 一个表里沙勋查询A列里不相同,但B列,C列,D列里面的内容相同,并列出A的记录。
- 如何按顺序查询表的所有数据?表没有索引
- if中的strcmp判断
- mysql集群(结点可以即有window和linux)
会员收入==会员收入
商品收入==商品收入
点卡收入==点卡收入
合计==临时卡消费总额
网费单机==(网费收入+会员收入)/dmmc(表)里的对应店名机器数量列。
商品单机==商品收入/dmmc(表)里的对应店名机器数量列。
点卡单机==点卡收入/dmmc(表)里的对应店名机器数量列。合计就是对应列相加
日均就是对应列相加之后/天数
CREATE TABLE `yybb_cx` (
`ID` int(11) NOT NULL auto_increment,
`日期` varchar(200) default NULL,
`网费收入` varchar(200) default NULL,
`会员收入` varchar(200) default NULL,
`临时卡消费总额` varchar(200) default NULL,
`商品收入` varchar(200) default NULL,
`点卡收入` varchar(200) default NULL,
`其他收入` varchar(200) default NULL,
`废品收入` varchar(200) default NULL,
`单机率` varchar(200) default NULL,
`现金流` varchar(200) default NULL,
`现金流比` varchar(200) default NULL,
`备注` varchar(255) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;--
-- 导出表中的数据 `yybb_cx`
-- INSERT INTO `yybb_cx` VALUES (1, '2013-10-27', '261895.6', '98528', '360423', '', '0', '0', '0', '3875.52', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (2, '2013-10-28', '427', '170', '597', '', '0', '0', '0', '6.63', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (3, '2013-10-28', '628', '254', '882', '', '0', '0', '0', '9.80', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (4, '2013-10-29', '424', '330', '754', '', '0', '0', '0', '8.38', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (5, '2013-10-29', '631', '530', '1161', '', '0', '0', '0', '12.90', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (6, '2013-10-30', '424', '55', '479', '', '0', '0', '0', '5.32', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (7, '2013-10-30', '494', '340', '834', '', '0', '0', '0', '9.27', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (8, '2013-10-31', '513', '20', '533', '', '0', '0', '0', '5.92', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (9, '2013-10-31', '604', '70', '674', '', '0', '0', '0', '7.49', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (10, '2013-11-01', '491', '0', '491', '153.5', '17', '0', '0', '5.45', '661.5', '7.35', '朱路乾');
INSERT INTO `yybb_cx` VALUES (11, '2013-11-01', '542', '281', '823', '135.5', '335', '0', '0', '9.14', '1293.5', '14.37', '朱路乾');
INSERT INTO `yybb_cx` VALUES (12, '2013-11-02', '480', '110', '590', '330.5', '290', '0', '0', '6.56', '1210.5', '13.45', '朱路乾');
INSERT INTO `yybb_cx` VALUES (13, '2013-11-02', '850', '270', '1120', '303.5', '240', '0', '0', '12.44', '1663.5', '18.48', '朱路乾');
INSERT INTO `yybb_cx` VALUES (14, '2013-11-03', '572', '140', '712', '248', '120', '0', '0', '7.82', '1080', '12', '朱路乾');
INSERT INTO `yybb_cx` VALUES (15, '2013-11-03', '484', '881', '1365', '144.5', '595', '0', '0', '15.17', '2104.5', '0', '23.38');
INSERT INTO `yybb_cx` VALUES (16, '2013-11-04', '473', '30', '503', '', '0', '0', '0', '5.59', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (17, '2013-11-04', '507', '211', '718', '', '0', '0', '0', '7.98', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (18, '2013-11-05', '464', '80', '544', '', '0', '0', '0', '6.04', '0', '0', NULL);
`ID` int(11) NOT NULL auto_increment,
`日期` varchar(200) default NULL,
`网费收入` varchar(200) default NULL,
`会员收入` varchar(200) default NULL,
`临时卡消费总额` varchar(200) default NULL,
`商品收入` varchar(200) default NULL,
`点卡收入` varchar(200) default NULL,
`其他收入` varchar(200) default NULL,
`废品收入` varchar(200) default NULL,
`单机率` varchar(200) default NULL,
`现金流` varchar(200) default NULL,
`现金流比` varchar(200) default NULL,
`备注` varchar(255) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;--
-- 导出表中的数据 `yybb_cx`
-- INSERT INTO `yybb_cx` VALUES (1, '2013-10-27', '261895.6', '98528', '360423', '', '0', '0', '0', '3875.52', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (2, '2013-10-28', '427', '170', '597', '', '0', '0', '0', '6.63', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (3, '2013-10-28', '628', '254', '882', '', '0', '0', '0', '9.80', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (4, '2013-10-29', '424', '330', '754', '', '0', '0', '0', '8.38', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (5, '2013-10-29', '631', '530', '1161', '', '0', '0', '0', '12.90', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (6, '2013-10-30', '424', '55', '479', '', '0', '0', '0', '5.32', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (7, '2013-10-30', '494', '340', '834', '', '0', '0', '0', '9.27', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (8, '2013-10-31', '513', '20', '533', '', '0', '0', '0', '5.92', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (9, '2013-10-31', '604', '70', '674', '', '0', '0', '0', '7.49', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (10, '2013-11-01', '491', '0', '491', '153.5', '17', '0', '0', '5.45', '661.5', '7.35', '朱路乾');
INSERT INTO `yybb_cx` VALUES (11, '2013-11-01', '542', '281', '823', '135.5', '335', '0', '0', '9.14', '1293.5', '14.37', '朱路乾');
INSERT INTO `yybb_cx` VALUES (12, '2013-11-02', '480', '110', '590', '330.5', '290', '0', '0', '6.56', '1210.5', '13.45', '朱路乾');
INSERT INTO `yybb_cx` VALUES (13, '2013-11-02', '850', '270', '1120', '303.5', '240', '0', '0', '12.44', '1663.5', '18.48', '朱路乾');
INSERT INTO `yybb_cx` VALUES (14, '2013-11-03', '572', '140', '712', '248', '120', '0', '0', '7.82', '1080', '12', '朱路乾');
INSERT INTO `yybb_cx` VALUES (15, '2013-11-03', '484', '881', '1365', '144.5', '595', '0', '0', '15.17', '2104.5', '0', '23.38');
INSERT INTO `yybb_cx` VALUES (16, '2013-11-04', '473', '30', '503', '', '0', '0', '0', '5.59', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (17, '2013-11-04', '507', '211', '718', '', '0', '0', '0', '7.98', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (18, '2013-11-05', '464', '80', '544', '', '0', '0', '0', '6.04', '0', '0', NULL);
CREATE TABLE `yybb_cx` (
`ID` int(11) NOT NULL auto_increment,
`日期` varchar(200) default NULL,
`网费收入` varchar(200) default NULL,
`会员收入` varchar(200) default NULL,
`临时卡消费总额` varchar(200) default NULL,
`商品收入` varchar(200) default NULL,
`点卡收入` varchar(200) default NULL,
`其他收入` varchar(200) default NULL,
`废品收入` varchar(200) default NULL,
`单机率` varchar(200) default NULL,
`现金流` varchar(200) default NULL,
`现金流比` varchar(200) default NULL,
`备注` varchar(255) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;--
-- 导出表中的数据 `yybb_cx`
-- INSERT INTO `yybb_cx` VALUES (1, '2013-10-27', '261895.6', '98528', '360423', '', '0', '0', '0', '3875.52', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (2, '2013-10-28', '427', '170', '597', '', '0', '0', '0', '6.63', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (3, '2013-10-28', '628', '254', '882', '', '0', '0', '0', '9.80', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (4, '2013-10-29', '424', '330', '754', '', '0', '0', '0', '8.38', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (5, '2013-10-29', '631', '530', '1161', '', '0', '0', '0', '12.90', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (6, '2013-10-30', '424', '55', '479', '', '0', '0', '0', '5.32', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (7, '2013-10-30', '494', '340', '834', '', '0', '0', '0', '9.27', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (8, '2013-10-31', '513', '20', '533', '', '0', '0', '0', '5.92', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (9, '2013-10-31', '604', '70', '674', '', '0', '0', '0', '7.49', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (10, '2013-11-01', '491', '0', '491', '153.5', '17', '0', '0', '5.45', '661.5', '7.35', '朱路乾');
INSERT INTO `yybb_cx` VALUES (11, '2013-11-01', '542', '281', '823', '135.5', '335', '0', '0', '9.14', '1293.5', '14.37', '朱路乾');
INSERT INTO `yybb_cx` VALUES (12, '2013-11-02', '480', '110', '590', '330.5', '290', '0', '0', '6.56', '1210.5', '13.45', '朱路乾');
INSERT INTO `yybb_cx` VALUES (13, '2013-11-02', '850', '270', '1120', '303.5', '240', '0', '0', '12.44', '1663.5', '18.48', '朱路乾');
INSERT INTO `yybb_cx` VALUES (14, '2013-11-03', '572', '140', '712', '248', '120', '0', '0', '7.82', '1080', '12', '朱路乾');
INSERT INTO `yybb_cx` VALUES (15, '2013-11-03', '484', '881', '1365', '144.5', '595', '0', '0', '15.17', '2104.5', '0', '23.38');
INSERT INTO `yybb_cx` VALUES (16, '2013-11-04', '473', '30', '503', '', '0', '0', '0', '5.59', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (17, '2013-11-04', '507', '211', '718', '', '0', '0', '0', '7.98', '0', '0', NULL);
INSERT INTO `yybb_cx` VALUES (18, '2013-11-05', '464', '80', '544', '', '0', '0', '0', '6.04', '0', '0', NULL);
一共两个表。 一个是smmc 一个是 yybb_cx 什么是通过什么字段连接?我大概描述下。 我有两个日期控件,当选择好了具体日期后。 他会查询出 excel表格那样的显示。计算的时候把,从单击率开始,就要牵扯到另外一个表的对应列了。 主要是yybb_cx表中的 两个数据相加 除以 smmc表中对应店面的机器数那列。