give_5

来源：互联网发布：金十数据开发者编辑：程序博客网时间：2024/05/23 20:30

SELECT * FROM t_location a WHERE a.name = '北京市';

##先判断是否有该手机号
SELECT * FROM t_yonghu b WHERE b.mobile IN('13017656763','15600399716');

##插入号码
INSERT INTO t_yonghu (mobile,PASSWORD,province,city,create_time,STATUS) VALUES ('13017656763','243176','41','4101','2014-12-01 15:32:21','1');
INSERT INTO t_yonghu (mobile,PASSWORD,province,city,create_time,STATUS) VALUES ('15600399716','243176','11','11','2014-12-02 18:32:21','1');

##更新渠道号和创建时间
UPDATE t_yonghu SET channelId='22163a5f63',create_time='2014-12-18 10:34:21' WHERE mobile IN('13017656763','15600399716','18613806675');

##检验数据
SELECT * FROM t_yonghu b WHERE b.mobile IN('13017656763','15600399716','18613806675');

##不需要执行
##delete from t_yonghu where mobile IN('13017656763','15600399716');

##导入zhongjiang信息
SELECT * FROM t_lottery_result;
SELECT * FROM t_lottery_activity;

INSERT INTO t_lottery_result(activeId,giftId,giftName,isPush,mobile,TIME) VALUES (1,2,'5元充值卡',1,'18613806675','2014-12-16 10:40:00');
INSERT INTO t_lottery_result(activeId,giftId,giftName,isPush,mobile,TIME) VALUES (1,2,'5元充值卡',1,'15650708956','2014-12-16 10:41:00');
INSERT INTO t_lottery_result(activeId,giftId,giftName,isPush,mobile,TIME) VALUES (1,2,'5元充值卡',1,'18600250521','2014-12-16 10:41:10');
INSERT INTO t_lottery_result(activeId,giftId,giftName,isPush,mobile,TIME) VALUES (1,2,'5元充值卡',1,'18601106725','2014-12-16 10:41:20');

##先查询符合条件的用户数
SELECT COUNT(*) FROM t_yonghu a WHERE a.create_time >= '2014-10-15' AND a.channelId = '';

INSERT INTO t_lottery_result(activeId,giftId,giftName,isPush,mobile,TIME,province,city) (SELECT 1,2,'5元充值卡',1,a.mobile,'2014-12-16 10:40:00',a.province,a.city FROM t_yonghu a WHERE a.create_time >= '2014-11-15' AND a.channelId = '渠道号');

DELETE FROM t_lottery_result WHERE mobile = '';

SELECT TYPE,CASE WHEN TYPE='16' THEN 1 ELSE 0 END),SUM(CASE WHEN TYPE='15' THEN 1 ELSE 0 END) FROM t_dictionary GROUP BY TYPE;

0 0