数据库|mysql教程
用户数,mysql,Java,统计
数据库-mysql教程
下载士网站源码下载,vscode c工程报错,远程操作ubuntu,tomcat并发消耗内存,交换机里面有sqlite,筋斗云爬虫助手安装包,php外文翻译,大连抖音seo软件,php源码 婚庆网站,css布局网页模板lzw
mysql函数实例-统计月登陆用户数
社区主站源码,ubuntu中can启动,tomcat8.0和70,java广度爬虫,禁止php 后面带参数,宁化seolzw
Java代码
android项目源码记账本,vscode语言编码选择,戴尔ubuntu设置,tomcat重启没有进程,sqlite3怎么删除一列,爬虫密令,php调用浏览器,免费自助建站平台seo,在线时时彩网站源码下载,dedecms校园模板lzw
CREATE FUNCTION statics_user_login_month() RETURNS int(11)COMMENT 月使用用户数/r/n BEGIN#Routine body goes here...DECLARE stopFlag INT DEFAULT 0 ;DECLARE _shop_id INT(11) DEFAULT 0;DECLARE _device VARCHAR(50);DECLARE _a_token CHAR(64) DEFAULT -1;DECLARE _s_token VARCHAR(64) DEFAULT NULL;DECLARE _use_count INT(11) DEFAULT 0;DECLARE _month_time date; #统计上月的食客登录用户DECLARE cur1 CURSOR FOR SELECT id, device, a_token, s_token FROM visitor_user WHERE DATE_FORMAT(off_time, \%Y-%m) = DATE_FORMAT((curdate() - 1), \%Y-%m); DECLARE CONTINUE HANDLER FOR NOT FOUND SET stopFlag=1; OPEN cur1; FETCH cur1 INTO _shop_id, _device, _a_token, _s_token;WHILE stopFlag = 0 doINSERT INTO report_user_login_month_detail(id, shop_id, month_time, device, a_token, s_token)VALUES (UUID(), _shop_id, DATE_FORMAT((curdate() - 1), \%Y-%m), _device, _a_token, _s_token); FETCH cur1 INTO _shop_id, _device, _a_token, _s_token;END WHILE;CLOSE cur1; set _month_time = DATE_FORMAT((curdate() - 1), \%Y-%m); #统计上月登录用户数SELECT COUNT(device) INTO _use_count FROM visitor_user WHERE DATE_FORMAT(off_time, \%Y-%m) = _month_time; INSERT INTO report_user_login_month(id, month_time, use_count, type_client)VALUES(UUID(), _month_time, _use_count, 0); RETURN 1; END
如果觉得《mysql函数实例-统计月登陆用户数【MySQL】》对你有帮助,请点赞、收藏,并留下你的观点哦!