INSERT into table VALUES 值为多个select查询结果_insert into table values(select )-CSDN博客

本文链接：https://blog.csdn.net/weixin_40283570/article/details/86674263

新建表

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))