mysql存储过程实例,查询多参数赋值
drop procedure if exists p_for_create_customer;
create procedure p_for_create_customer()
begin
declare ii int default 0;
declare i int default 1;
declare minss int default 0;
declare idd int;
declare start_d datetime;
declare channel_code_ VARCHAR(255);
declare end_d datetime;
declare minutes int;
select id,countt,start_date,end_date,channel_code into idd,ii,start_d,end_d,channel_code_ from schedu_create_info where is_effective='true' limit 1;
select timestampdiff(minute,start_d,end_d) into minss from dual;
select idd from dual;
loop_example : loop
update schedu_create_info set is_effective='true' where id = idd;
set i = i + 1;
insert into crm_t_customer (mobile ,name ,idcard,channel_code,create_date)
value(CONCAT('1*********',rand_num(0,9)),'***','***',channel_code_,DATE_ADD(start_d,INTERVAL rand_num(0,minss) MINUTE) );
if i >ii then
leave loop_example;
end if;
end loop;
end;
call p_for_create_customer();
drop procedure if exists p_for_create_customer;
create procedure p_for_create_customer()
begin
declare ii int default 0;
declare i int default 1;
declare minss int default 0;
declare idd int;
declare start_d datetime;
declare channel_code_ VARCHAR(255);
declare end_d datetime;
declare minutes int;
select id,countt,start_date,end_date,channel_code into idd,ii,start_d,end_d,channel_code_ from schedu_create_info where is_effective='true' limit 1;
select timestampdiff(minute,start_d,end_d) into minss from dual;
select idd from dual;
loop_example : loop
update schedu_create_info set is_effective='false' where id = idd;
set i = i + 1;
insert into crm_t_customer (mobile ,name ,idcard,channel_code,create_date)
value(CONCAT('1*********',rand_num(0,9)),'***','***',channel_code_,DATE_ADD(start_d,INTERVAL rand_num(0,minss) MINUTE) );
if i >ii then
leave loop_example;
end if;
end loop;
end;
call p_for_create_customer();
delete from crm_t_customer;
select * from schedu_create_info;
select * from crm_t_customer;
call p_for_create_customer();
select rand_num(2,54);
alter event event_task_customer ON COMPLETION PRESERVE ENABLE;
alter event event_task_customer ON COMPLETION PRESERVE DISABLE;
DROP EVENT event_task_customer;
create event event_task_customer
on schedule every 2 minute
on completion PRESERVE
do call p_for_create_customer();
最新文章
- 掌握 Linux PC 性能之基准测试
- java中如何获取昨天的当前日期
- 织梦DedeCms用SQL语句调用数据库任意内容方法
- 对.Net系统架构改造的一点经验和教训
- Dynamic Programming - Part1
- Sizzle引擎执行的流程图
- Delphi 动态改变Rzsplitter的Orientation(方向)属性
- github page使用
- Struts2学习笔记（一） Struts2配置文件的配置
- centos 6.4 x64安装bugfree
- Selenium+IDEA+Maven+TestNG环境搭建
- LANMP系列教程之php编译安装CentOS7环境
- Spring Data 起步
- 题解-CTSC2012 熟悉的文章
- （27）session（设置值、取值、修改、删除）
- CyberArticle(eLib电子图书馆)网文快捕
- mac下安装apc并且使用
- jq判断鼠标滚轴向上滚动还是向下滚动
- MFC实现简单飞机大战（含游戏声音）
- Ubuntu中在QT中配置OpenGL