创建一个定时器，实现以下功能

定时器要求：

1. 定时执行某存储过程，存储过程实现向某表中插入一条数据
2. 每分钟执行一次

SET GLOBAL event_scheduler = ON;

create table `p_test` (

 `id` int(11) not null auto_increment,

 `name` varchar(8) default null,

 `num` varchar(6) default null,

 `createtime` timestamp null default current_timestamp on update current_timestamp,

 primary key (`id`)

);

create procedure myproc()

begin

declare i int;

declare v_name varchar(8);

declare v_num varchar(6);

   declare v_random int;

set i = 0;

while i < 2 do

set v_name=concat('javakc',i);

set v_random= truncate(rand()*1000000,0);

set v_num=lpad(v_random,6,'0');

insert into p_test (name,num) values (v_name ,v_num );

set i = i + 1;

end while;

end;

create event e_minute

on schedule

every 1 minute

ends date_add(now(),interval 10 minute)

do call myproc();

show processlist;

show events;

select * from p_test