mysql统计留存率

欢迎进入Linux社区论坛，与200万技术人员互动交流 >>进入 Sql代码 begin declare i int; declare numareaId int(10); declare currentareaId int(10); SELECT COUNT(areaId),MIN(areaId) INTO @a,@b FROM option_area_info; SET numareaId=@a; SET currentar

欢迎进入linux社区论坛，与200万技术人员互动交流 >>进入

　　Sql代码

　　begin

　　declare i int;

　　declare numareaId int(10);

　　declare currentareaId int(10);

　　SELECT COUNT(areaId),MIN(areaId) INTO @a,@b FROM option_area_info;

　　SET numareaId=@a;

　　SET currentareaId=@b;

　　loop1:WHILE numareaId>0 DO

　　SET @AID = currentareaId;

SDCMS-B2C商城网站管理系统

SDCMS-B2C商城网站管理系统是一个以php+MySQL进行开发的B2C商城网站源码。 本次更新如下： 【新增的功能】 1、模板引擎增加包含文件父路径过滤； 2、增加模板编辑保存功能过滤； 3、增加对统计代码参数的过滤 4、新增会员价设置（每个商品可以设置不同级不同价格） 5、将微信公众号授权提示页单独存放到data/wxtemp.php中，方便修改 【优化或修改】 1、修改了check_b

13

查看详情

　　SET i=1;

　　while i

　　if exists(select * from statistics_player_l where createTime>=date_sub(curdate(),interval i day) and createTime

　　update statistics_player_l set oneDayPlayer=(select ((select count(distinct playerId) from log_login where registerTime=date_sub(curdate(),interval i day) and loginTime>=date_add(date_sub(curdate(),interval i day),interval 1 day) and loginTime=date_sub(curdate(),interval i day) and createTime

　　update statistics_player_l set twoDayPlayer=(select ((select count(distinct playerId) from log_login where registerTime=date_sub(curdate(),interval i day) and loginTime>=date_add(date_sub(curdate(),interval i day),interval 2 day) and loginTime=date_sub(curdate(),interval i day) and createTime

　　update statistics_player_l set threeDayPlayer=(select ((select count(distinct playerId) from log_login where registerTime=date_sub(curdate(),interval i day) and loginTime>=date_add(date_sub(curdate(),interval i day),interval 3 day) and loginTime=date_sub(curdate(),interval i day) and createTime

　　update statistics_player_l set fourDayPlayer=(select ((select count(distinct playerId) from log_login where registerTime=date_sub(curdate(),interval i day) and loginTime>=date_add(date_sub(curdate(),interval i day),interval 4 day) and loginTime=date_sub(curdate(),interval i day) and createTime

　　update statistics_player_l set fiveDayPlayer=(select ((select count(distinct playerId) from log_login where registerTime=date_sub(curdate(),interval i day) and loginTime>=date_add(date_sub(curdate(),interval i day),interval 5 day) and loginTime=date_sub(curdate(),interval i day) and createTime

　　update statistics_player_l set sixDayPlayer=(select ((select count(distinct playerId) from log_login where registerTime=date_sub(curdate(),interval i day) and loginTime>=date_add(date_sub(curdate(),interval i day),interval 6 day) and loginTime=date_sub(curdate(),interval i day) and createTime

　　update statistics_player_l set sevenDayPlayer=(select ((select count(distinct playerId) from log_login where registerTime=date_sub(curdate(),interval i day) and loginTime>=date_add(date_sub(curdate(),interval i day),interval 7 day) and loginTime=date_sub(curdate(),interval i day) and createTime

　　end if;

　　SET i=i+1;

　　end while;

　　SET numareaId=numareaId-1;

　　SET currentareaId=currentareaId+1;

　　END WHILE loop1;

　　end