MySQL 按日期模拟查询

– 查询出付费的所有通道
select channels, count(*) from t_auth_core_flow where res_code not in (’-10000’,‘10075’,‘10094’‘10095’,‘10097’,‘10105’,‘10110’,‘10112’) GROUP BY channels

– 查询联润表
– 查询2018年所有
select * from t_lianrun_flow where create_time > ‘2018-04-01 00:00:00’ and ‘2018-12-31 24:59:59’ ORDER BY create_time DESC

– mysql 查询时间范围模拟查询 联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– mysql 一月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

– mysql 二月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

– mysql 三月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

– mysql 四月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

– mysql 5月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

– mysql 6月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– mysql 7月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– mysql 8月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

– mysql 10月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

– mysql 11月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– mysql 12月份联润
select * from t_lianrun_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_lianrun_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_lianrun_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

– mysql 查询时间范围模拟查询 银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

– mysql 一月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-01-31’

– mysql 2月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-02-01’ and ‘2018-02-31’

– mysql 3月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-03-01’ and ‘2018-03-31’

– mysql 4月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-04-01’ and ‘2018-04-31’

– mysql 5月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-05-01’ and ‘2018-05-31’

– mysql 6月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-06-01’ and ‘2018-06-31’

– mysql 7月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-07-01’ and ‘2018-07-31’

– mysql 8月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-08-01’ and ‘2018-08-31’

– mysql 9月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-09-01’ and ‘2018-09-31’

– mysql 10月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-10-01’ and ‘2018-10-31’

– mysql 11月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-11-01’ and ‘2018-11-31’

– mysql 12月份银邮
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认证不一致%’ and date_format(create_time,’%Y-%m-%d’) between ‘2018-12-01’ and ‘2018-12-31’

– mysql 查询时间范围模拟查询 小河
select * from t_unionpay_bank_flow where date_format(create_time,’%Y-%m-%d’) between ‘2018-01-01’ and ‘2018-12-31’

select * from t_unionpay_bank_flow where res_desc like ‘%认