建立临时表,查询数据后,删除临时表【附件变量赋值】
#建立临时表
CREATE TEMPORARY TABLE `yonghu` (
`归属省` varchar(50) DEFAULT NULL,
`归属市` varchar(50) DEFAULT NULL,
`用户号码` varchar(50) DEFAULT NULL,
`发券流水号` varchar(50) NOT NULL,
`活动编码` varchar(50) DEFAULT NULL,
`活动名称` varchar(50) DEFAULT NULL,
`领用日期` varchar(50) DEFAULT NULL,
`领用时间` varchar(50) DEFAULT NULL,
`电子券状态` varchar(50) DEFAULT NULL,
`券类别` varchar(50) DEFAULT NULL,
`电子券金额` double(10,0) DEFAULT NULL,
`余额` double(10,0) DEFAULT NULL,
`失效日期` varchar(50) DEFAULT NULL,
`原发券流水` varchar(50) DEFAULT NULL,
`是否分月` varchar(50) DEFAULT NULL,
`是否分期` varchar(50) DEFAULT NULL,
`分期类型` varchar(50) DEFAULT NULL,
PRIMARY KEY (`发券流水号`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
SET @phoneid = '18616391933';
INSERT INTO `yonghu`
(SELECT * FROM `202301` WHERE `用户号码`like concat( '%' ,@phoneid, '%' ));
INSERT INTO `yonghu`
(SELECT * FROM `202212` WHERE `用户号码`like concat( '%' ,@phoneid, '%' ));
INSERT INTO `yonghu`
(SELECT * FROM `202211` WHERE `用户号码`like concat( '%' ,@phoneid, '%' ));
INSERT INTO `yonghu`
(SELECT * FROM `202210` WHERE `用户号码`like concat( '%' ,@phoneid, '%' ));
SELECT `用户号码`,`活动编码`,`活动名称`,`领用日期`,`电子券金额`,`余额`,`失效日期`,`是否分期`,`分期类型` FROM `yonghu`ORDER BY `领用日期`;
DROP TABLE `yonghu`