BEGIN
declare personId varchar(25);
declare i int;
declare count int;
declare days int;
DECLARE cursorName CURSOR FOR select id from person where username like 'j0%';
OPEN cursorName ;
set i=1;
while i<10001 do
FETCH cursorName INTO personId;
BEGIN
/**CURDATE();*/
SET count=1;
set days=0;
WHILE count<=2800 do
if(count mod 200 =0) then
set days=days+1;
end if;
INSERT into click(persion_id,click_count,url_id,action_mode,begin_time,action_flag,period,url) VALUES(personId,1, CONCAT(personId,'_url_', count),1,DATE_SUB(CURRENT_TIMESTAMP(),INTERVAL CONCAT(days, " 0:0:0" ) DAY_SECOND),1,0,CONCAT('www.baidu.com'));
#insert into his (click_time,user_id,url_id,version) VALUES (DATE_SUB(CURRENT_TIMESTAMP(),INTERVAL CONCAT(days, " 0:0:0" ) DAY_SECOND ),personId, CONCAT(personId,'_url_', count),0);
SET count=count+1;
end while;
END ;
set i=i+1;
end while;
CLOSE cursorName;
COMMIT;
end
/*DATE_SUB(CURRENT_TIMESTAMP(),INTERVAL CONCAT(days, " 0:0:0" ) CURRENT_TIMESTAMP()是获得当前时间，而Date_sub函数是时间减1*/
