mysql+存储过程+参数赋值_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_