调试易

代码如下 drop和create单独拿出来没问题 后面的declare和select into，insert into单独也没问题 ，写到一起出错
错误显示在21行
/*商户总数*/
DECLARE tenant_count_g DOUBLE;求解决，谢大神BEGIN
DROP TEMPORARY TABLE IF EXISTS tenant_monitor; 
CREATE TEMPORARY  TABLE tenant_monitor 
(
goods_count DOUBLE,
goods_avg DOUBLE,
goods_increase DOUBLE,
avg_goods_increase DOUBLE,
receipts_count DOUBLE, 
receipts_avg DOUBLE,
receipts_increase DOUBLE,
avg_receipts_increase DOUBLE
);
/*商品数量监控*/
/*累计*/
DECLARE goods_count DOUBLE;
/*商户总数*/
DECLARE tenant_count_g DOUBLE;
/*平均*/
DECLARE goods_avg DOUBLE;
/*第一条日期*/
DECLARE first_day_g INT;
/*今日日期*/
DECLARE today_day_g INT;
/*经过天数*/
DECLARE day_count_g int;
/*昨日增长*/
DECLARE goods_increase double;
/*日均增长*/
DECLARE avg_goods_increase DOUBLE;/*单据数量监控*/
/*累计*/
DECLARE receipts_count DOUBLE;
DECLARE tenant_count_s DOUBLE;
/*平均*/
DECLARE receipts_avg DOUBLE;
/*昨日增长*/
DECLARE receipts_increase DOUBLE;
/*第一条日期*/
DECLARE first_day_s INT;
/*今日日期*/
DECLARE today_day_s INT;
/*经过天数*/
DECLARE day_count_s int;
/*日均增长*/
DECLARE avg_receipts_increase DOUBLE; SELECT count(*) INTO goods_count  from `saas-web`.`goods` g where g.is_deleted = 0;
  SELECT count(*) into tenant_count_g FROM ( select count(*) from `saas-web`.`goods` g where g.is_deleted = 0 GROUP BY g.tenant_id) c;
SET goods_avg = goods_count/tenant_count_g;
SELECT count(*) INTO goods_increase FROM `saas-web`.`goods` g WHERE TO_DAYS( NOW( ) ) - TO_DAYS(g.create_at) <= 0 AND is_deleted = 0;
select TO_DAYS(create_at) INTO first_day_g from `saas-web`.`goods` g ORDER BY  g.create_at ASC limit 1;
select TO_DAYS(NOW()) INTO today_day_g FROM DUAL;
SET day_count_g = today_day_g - first_day_g;
SET avg_goods_increase = goods_count / day_count_g; SELECT count(*) INTO receipts_count  from `saas-web`.`sale` s where s.is_deleted = 0;
  SELECT count(*) into tenant_count_s FROM ( select count(*) from `saas-web`.`sale` s where s.is_deleted = 0 GROUP BY s.tenant_id) c;
SET receipts_avg = receipts_count/tenant_count_s;
SELECT count(*) INTO receipts_increase FROM `saas-web`.`sale` s WHERE TO_DAYS( NOW( ) ) - TO_DAYS(s.checkout_at) <= 0 AND s.is_deleted = 0;
select TO_DAYS(checkout_at) INTO first_day_s from `saas-web`.`sale` s ORDER BY  s.checkout_at ASC limit 1;
select TO_DAYS(NOW()) INTO today_day_s FROM DUAL;
SET day_count_s = today_day_s - first_day_s;
SET avg_receipts_increase = receipts_count / day_count_s;


INSERT INTO tenant_monitor (`goods_count`,`goods_avg`,`goods_increase`,`avg_goods_increase`,`receipts_count`,`receipts_avg`,`receipts_increase`,`avg_receipts_increase`)
VALUES (goods_count,goods_avg,goods_increase,avg_goods_increase,receipts_count,receipts_avg,receipts_increase,avg_receipts_increase);
END