mysql 存储过程 随笔
CREATE PROCEDURE `g2`( in sts int,in type int, code varchar(20),in s int)
begin
declare i int;
declare a int;
declare b int;
declare t varchar(20) default '';
set t=DATE_FORMAT(NOW(), '%Y-%m');
set i = 1;
truncate table faw_form_a;
loop_example : loop
if (type = 1) then
select if(id,count(id),0) as id,if(status=s,s,s) as status into a,b
from faw_form_operating where status =s and
DATE_FORMAT(FROM_UNIXTIME(add_time),'%Y-%m-%d')=concat(t,'-',i) and
userid in (select userid from table_name where dealer_code=code and userid!=0);
insert into faw_form_a (id,m,c,s) values (null,i,a,b);
else
select if(id,count(id),0) as id,if(status=s,s,s) as status into a,b
from faw_form_operating where status =s and
DATE_FORMAT(FROM_UNIXTIME(add_time),'%m')=i and userid in (select userid from table_name where dealer_code=code and userid!=0);
insert into faw_form_a (id,m,c,s) values (null,i,a,b);
end if;
set i = i + 1;
if i > sts then
leave loop_example;
end if;
end loop;
select c,m,s from faw_form_a group by s,m;
end;
调用 call g2(1,2,"xxxx",1)
最新文章
- Java_动态编译总结
- cocos2dx 3.1获取系统当前时间
- Java NIO通信框架在电信领域的实践
- jQuery Ajax 实例 ($.ajax、$.post、$.get)转
- jquery全选框的实现
- 开源第三方登录组件OAuthLogin2.0 支持QQ,阿里巴巴,淘宝,京东,蘑菇街,有赞等平台
- mysql 运维常见操作
- MFC中打开一个获取路径的对话框
- 用一个div模拟textarea的实现
- 『vue踩坑日常』 在index.html中引入静态文件不生效
- Java引入的一些新特性
- Mac os 下brew的安装与使用—— Homebrew
- java面试题03
- webstorm的快捷键总结
- Spring监听,ApplicationListener
- 杂谈1.py
- 状压DP入门详解+题目推荐
- install ros-indigo-map-server
- a+b_1
- hdu 1422(贪心)