mysql 使用select插入多条数据，insert into （1,2,3,4,）select（1，2,3,4）

 SET @yesterday = CURDATE() - INTERVAL n DAY; # 前N天的日期，n通常为1，即昨天    INSERT IGNORE mob_report.day_coupon_report (        mdate,         id,         day_release_coupon_count,        day_writeoff_coupon_count,        shop_id,        shop_name,        coupon_id,        coupon_name,        day_shop_release_coupon_count,        day_shop_writeoff_coupon_count,        create_time)    SELECT         @yesterday,         NULL,        (SELECT COUNT(1) FROM mob_coupon.member_receive_coupon nrc WHERE @yesterday = DATE(FROM_UNIXTIME(nrc.create_time))), # 查询前N天优惠券发放总数        (SELECT COUNT(1) FROM mob_coupon.writeoff_coupon_record wcr WHERE @yesterday = DATE(FROM_UNIXTIME(wcr.create_time))), # 查询前N天优惠券核销总数        tmp.shop_id,        tmp.shop_name,        tmp.coupon_id,        tmp.coupon_name,        tmp.day_shop_release_coupon_count,        tmp.day_shop_writeoff_coupon_count,        UNIX_TIMESTAMP(NOW())    FROM (        # 查询前N天按优惠券分组的发放数量，核销数量        SELECT            SUM(day_shop_release_coupon_count) AS day_shop_release_coupon_count,            SUM(day_shop_writeoff_coupon_count) AS day_shop_writeoff_coupon_count,            coupon_id,            `name` AS coupon_name,            shop_id,            shop_name        FROM (            # 查询前N天按优惠券分组的发放数量，每组核销数量作为0            SELECT                 COUNT(1) AS day_shop_release_coupon_count,                0 AS day_shop_writeoff_coupon_count,                coupon_id,                b.name,                b.shop_id,                c.shop_name            FROM mob_coupon.member_receive_coupon a            LEFT JOIN mob_coupon.coupon_info b ON a.coupon_id = b.id             LEFT JOIN mob_base_info.shop_info c ON b.shop_id = c.id            WHERE @yesterday = DATE(FROM_UNIXTIME(a.create_time))            GROUP BY a.coupon_id            UNION ALL            # 查询前N天按优惠券分组的核销数量，每组发放数量作为0            SELECT                 0 AS day_shop_release_coupon_count,                COUNT(1) AS day_shop_writeoff_coupon_count,                coupon_id,                b.name,                b.shop_id,                c.shop_name            FROM mob_coupon.writeoff_coupon_record a            LEFT JOIN mob_coupon.coupon_info b ON a.coupon_id = b.id             LEFT JOIN mob_base_info.shop_info c ON b.shop_id = c.id            WHERE @yesterday = DATE(FROM_UNIXTIME(a.create_time))            GROUP BY a.coupon_id        ) t        GROUP BY t.coupon_id    ) tmp;