新增用户统计,仅用作备忘。
CREATE FUNCTION `statics_user_new`() RETURNS int(11) COMMENT '统计新增用户' BEGIN #Routine body goes here... DECLARE stopFlag INT DEFAULT 0 ; DECLARE _shop_id VARCHAR(11) DEFAULT NULL; #餐厅id DECLARE _device VARCHAR(50) DEFAULT NULL; #手机设备号 DECLARE _a_token CHAR(64) DEFAULT NULL; #与苹果服务器会话 DECLARE _s_token VARCHAR(64) DEFAULT NULL; #与点菜网服务器会话 DECLARE _counts INT DEFAULT 0; #查询昨天新创建的用户 DECLARE cur1 CURSOR FOR SELECT id, device, a_token, s_token FROM visitor_user where DATE_FORMAT(create_time, '%Y-%m-%d') = DATE_SUB(DATE_FORMAT(now(),'%Y-%m-%d'), INTERVAL 1 DAY); DECLARE CONTINUE HANDLER FOR NOT FOUND SET stopFlag=1; OPEN cur1; FETCH cur1 INTO _shop_id, _device, _a_token, _s_token; WHILE stopFlag = 0 do INSERT INTO report_user_new_day_detail(id, shop_id, device, a_token, s_token) values (UUID(), _shop_id, _device, _a_token, _s_token); FETCH cur1 INTO _shop_id, _device, _a_token, _s_token; END WHILE; CLOSE cur1; #统计日新增用户数 SELECT COUNT(device) INTO _counts FROM visitor_user where DATE_FORMAT(create_time, '%Y-%m-%d') = DATE_SUB(DATE_FORMAT(now(),'%Y-%m-%d'), INTERVAL 1 DAY); INSERT INTO report_user_new_day(id, day_time, new_counts, type_client) VALUES(UUID(), DATE_SUB(DATE_FORMAT(now(),'%Y-%m-%d'), INTERVAL 1 DAY), _counts, 0); SET _counts = 1; RETURN _counts; END
相关推荐
mysql-connector-java-5.1.27.jar mysql-connector-java-5.1.27.jar
mysql-connector-java-5.1.40.zip和mysql-connector-java-5.1.10.jar
mysql-connector-java-5.1.7-bin.jar
mysql-connector-java-5.1.37.zip
mysql驱动包 mysql-connector-java-5.1.13-bin.jar 方便快捷获取。。。
mysql-connector-odbc-5.2.7-winx64.msi MySQL Connector/ODBC 有时也可以叫做 MyODBC,用户可以用ODBC (Open Database Connectivity,开放数据库互联)数据库连接Mysql的服务器。比如说,用户可以使用Windows或者...
将要使用的是mysql-connector-java-5.1.30-bin-g.jar和mysql-connector-java-5.1.30-bin.jar 配置 在C:\Program Files\Java目录下建立mysqlforjdbc子目录,进入该目录将mysql-connector-java-5.1.30-bin.jar到该...
5.6.20 最新JDBC mysql-connector-java-5.1.32-bin.jar
mysql-connector-java-5.1.7-bin.jar,MySQL的jdbc的驱动
MySQL官方提供的驱动包 mysql-connector-java-5.1.30.zip
mysql-connector-java-5.1.47 jar包,在利用jdbc连接数据库用
mysql-connector-odbc-5.1.7-winx64 单独安装包
java连接mysql数据库的jar包,最新纯净正版。直接将mysql-connector-java-5.1.45-bin.jar导入项目中即可使用。
基于hibernate的mysql分表分库实例-mysql-cluster-hibernate
mysql-connector-java-5.1.42-bin.jar 官网下载的驱动
这是MySQL最新的jar,mysql-connector-java-8.0.18.jar
mysql-connector-odbc-5.3.4-winx64.msi
mysql-connector-java-5.1.40-bin.jar连接器,用于在hive和mysql的数据库连接
mysql-connector-java-3.0.16-ga-bin.jar 连接mysql的java包
网上共享了很多mysql-connector-odbc的驱动,但多半只支持mysql4.0,这个版本的mysql-connector-odbc可以支持mysql5.0以上版本,欢迎大家使用。