1、被调用的存储过程编码
CREATE DEFINER=`datahs`@`%` PROCEDURE `p_dorm_cnt_daily`(IN `p_statistics_date` int)
BEGIN
delete from datatest.tmp_dorm_cnt_daily where statistics_date=p_statistics_date;
insert into datatest.tmp_dorm_cnt_daily
select p_statistics_date statistics_date,a3.city_name,count(*) drom_cnt
from (select dorm_id from h_60_dormentrydormrecord where (unbund_time is null or unbund_time='0' or FROM_UNIXTIME(unbund_time,'%Y%m%d')>p_statistics_date) and FROM_UNIXTIME(add_time,'%Y%m%d')<=p_statistics_date group by dorm_id) a1
left join h_60_dorm a2 on a1.dorm_id=a2.dorm_id
left join h_60_areajoin a3 on a2.site_id=a3.site_id
group by a3.city_name;
commit;
END
2、遁环游标所使用的参数表
建表语句:
建表语句: