mysql INSET INTO ，SELECT数据

public void insertOrgReport_O(String tableName, String time) {
        StringBuilder sql = new StringBuilder();
        sql.append("INSERT INTO ").append(tableName).append(" (createTime,remark,balanceUSDT,balanceBTC,balanceETH,balanceCNY,balanceUSD,");
        sql.append(" rechargeUSDT,rechargeBTC,rechargeETH,rechargeCNY,rechargeUSD,withdrawalUSDT,withdrawalBTC,withdrawalETH,");
        sql.append(" withdrawalCNY,withdrawalUSD,rechargeAcountUSDT,rechargeAcountBTC,rechargeAcountETH,rechargeAcountCNY,");
        sql.append(" rechargeAcountUSD,withdrawalAcountUSDT,withdrawalAcountBTC,withdrawalAcountETH,withdrawalAcountCNY,");
        sql.append(" withdrawalAcountUSD,totalRechargeAcount,totalWithdrawalAcount,speedOrderAcount,contractOrderAcount,");
        sql.append(" financialOrderAcount,dividendMoney,rakebackMoney,totalFee,reportDate,registerAcount,fristRechargeAcount,");
        sql.append(" userAdminName,userAdminLoginName,userAdminType,userAdminId,userTid)");

        sql.append(" select now() AS createTime, concat(u.type,'-',u.loginname,'-',u.name) AS remark,");
        sql.append(" IFNULL(SUM(a.balanceUSDT),0.00) as balanceUSDT,");
        sql.append(" IFNULL(SUM(a.balanceBTC),0.00) as balanceBTC,");
        sql.append(" IFNULL(SUM(a.balanceETH),0.00) as balanceETH,");
        sql.append(" IFNULL(SUM(a.balanceCNY),0.00) as balanceCNY,");
        sql.append(" IFNULL(SUM(a.balanceUSD),0.00) as balanceUSD,");

        sql.append(" IFNULL(SUM(a.rechargeUSDT),0.00) as rechargeUSDT,");
        sql.append(" IFNULL(SUM(a.rechargeBTC),0.00) as rechargeBTC,");
        sql.append(" IFNULL(SUM(a.rechargeETH),0.00) as rechargeETH,");
        sql.append(" IFNULL(SUM(a.rechargeCNY),0.00) as rechargeCNY,");
        sql.append(" IFNULL(SUM(a.rechargeUSD),0.00) as rechargeUSD,");

        sql.append(" IFNULL(SUM(a.withdrawalUSDT),0.00) as withdrawalUSDT,");
        sql.append(" IFNULL(SUM(a.withdrawalBTC),0.00) as withdrawalBTC,");
        sql.append(" IFNULL(SUM(a.withdrawalETH),0.00) as withdrawalETH,");
        sql.append(" IFNULL(SUM(a.withdrawalCNY),0.00) as withdrawalCNY,");
        sql.append(" IFNULL(SUM(a.withdrawalUSD),0.00) as withdrawalUSD,");

        sql.append(" IFNULL(SUM(a.rechargeAcountUSDT),0.00) as rechargeAcountUSDT,");
        sql.append(" IFNULL(SUM(a.rechargeAcountBTC),0.00) as rechargeAcountBTC,");
        sql.append(" IFNULL(SUM(a.rechargeAcountETH),0.00) as rechargeAcountETH,");
        sql.append(" IFNULL(SUM(a.rechargeAcountCNY),0.00) as rechargeAcountCNY,");
        sql.append(" IFNULL(SUM(a.rechargeAcountUSD),0.00) as rechargeAcountUSD,");

        sql.append(" IFNULL(SUM(a.withdrawalAcountUSDT),0.00) as withdrawalAcountUSDT,");
        sql.append(" IFNULL(SUM(a.withdrawalAcountBTC),0.00) as withdrawalAcountBTC,");
        sql.append(" IFNULL(SUM(a.withdrawalAcountETH),0.00) as withdrawalAcountETH,");
        sql.append(" IFNULL(SUM(a.withdrawalAcountCNY),0.00) as withdrawalAcountCNY,");
        sql.append(" IFNULL(SUM(a.withdrawalAcountUSD),0.00) as withdrawalAcountUSD,");

        sql.append(" IFNULL(SUM(a.totalRechargeAcount),0.00) as totalRechargeAcount,");
        sql.append(" IFNULL(SUM(a.totalWithdrawalAcount),0.00) as totalWithdrawalAcount,");
        sql.append(" IFNULL(SUM(a.speedOrderAcount),0.00) as speedOrderAcount,");
        sql.append(" IFNULL(SUM(a.contractOrderAcount),0.00) as contractOrderAcount,");
        sql.append(" IFNULL(SUM(a.financialOrderAcount),0.00) as financialOrderAcount,");
        sql.append(" IFNULL(SUM(a.financial),0.00) as dividendMoney,");
        sql.append(" IFNULL(SUM(a.rakeback),0.00) as rakebackMoney,");
        sql.append(" IFNULL(SUM(a.fee),0.00) as totalFee,");
        sql.append(" STR_TO_DATE('").append(time).append("','%Y_%m_%d') AS reportDate,");
        sql.append(" (SELECT count(1) FROM ok_coin_userinfo a WHERE a.orgId = u.id AND DATE_FORMAT(a.createTime,'%Y_%m_%d')='").append(time).append("') AS registerAcount,");
        sql.append(" (SELECT count(1) FROM ok_coin_userinfo a WHERE a.orgId = u.id AND DATE_FORMAT(a.firstRechargeTime,'%Y_%m_%d')='").append(time).append("') AS fristRechargeAcount,");
        sql.append(" u.name as userAdminName,");
        sql.append(" u.loginname as userAdminLoginName,");
        sql.append(" u.type as userAdminType,");
        sql.append(" u.id as userAdminId,");
        sql.append(" u.tid as userTid");

        sql.append(" FROM ok_coin_useradmininfo u");
        sql.append(" LEFT JOIN z_his_userreport_").append(time).append(" a ON u.id = a.orgId");
        sql.append(" WHERE u.type=2");
        Map<String, Object> paramMap = new HashMap<String, Object>();
        paramMap.put("tableName", tableName);
        log.debug("className:{}.methodName:{},sql:{},param:{}", this.getClass().getName(),
                Thread.currentThread().getStackTrace()[1].getMethodName(), sql.toString(), paramMap);
        tpl.update(sql.toString(), paramMap);
    }