新建表
CREATE TABLE `platform_loss_ratio` (
`platform` varchar(32) NOT NULL COMMENT '平台名称',
`platform_jc` varchar(10) NOT NULL COMMENT '平台简称',
`level0` int(11) DEFAULT NULL COMMENT '亏损0-10000',
`level1` int(11) DEFAULT NULL COMMENT '亏损10001-50000',
`level2` int(11) DEFAULT NULL COMMENT '亏损50001-100000',
`level3` int(11) DEFAULT NULL COMMENT '亏损100001-500000',
`level4` int(11) DEFAULT NULL COMMENT '亏损500001-1000000',
`level5` int(11) DEFAULT NULL COMMENT '亏损1000001-3000000',
`level6` int(11) DEFAULT NULL COMMENT '亏损3000001-5000000',
`level7` int(11) DEFAULT NULL COMMENT '亏损5000001-10000000',
`level8` int(11) DEFAULT NULL COMMENT '亏损大于10000000'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
插入数据
INSERT into platform_loss_ratio VALUES('安克','ak',
(SELECT count(*) FROM adk_profit_loss_new t where t.profit_loss<0 and t.profit_loss >=-10000),
(SELECT count(*) FROM adk_profit_loss_new t where t.profit_loss<-10000 and t.profit_loss >=-50000),
(SELECT count(*) FROM adk_profit_loss_new t where t.profit_loss<-50000 and t.profit_loss >=-100000),
(SELECT count(*) FROM adk_profit_loss_new t where t.profit_loss<-100000 and t.profit_loss >=-500000),
(SELECT count(*) FROM adk_profit_loss_new t where t.profit_loss<-500000 and t.profit_loss >=-1000000),
(SELECT count(*) FROM adk_profit_loss_new t where t.profit_loss<-1000000 and t.profit_loss >=-3000000),
(SELECT count(*) FROM adk_profit_loss_new t where t.profit_loss<-3000000 and t.profit_loss >=-5000000),
(SELECT count(*) FROM adk_profit_loss_new t where t.profit_loss<-5000000 and t.profit_loss >=-10000000),
(SELECT count(*) FROM adk_profit_loss_new t where t.profit_loss<-10000000))