利用存储过程写入测试数据

 

DELIMITER //  
drop procedure if exists  useCursor // 
create procedure chengchInsert()

begin

declare i int;

declare datetime varchar(20);
declare message varchar(50);

set i=1;
select CURRENT_TIMESTAMP() into @startTime;
while(i<2000) do

if not exists(select id from messages where id=i ) then
     select now() into dateTime;
     set message=concat('message','_',i,'_',dateTime);
    insert into messages(id,senderid,message,mediaurl,sendtime,sendip,country,datasource)values(i,1,message,'http://photo2.idate.163.com/album/25/1/26/b9ed3adaf96ce5c10e7ca9b7abbe4b29/16872601//lit/PORTRAIT_CERT195',dateTime,'12.323.56.3','中国','163');

end if;

set i=i+1;

end while;
select CURRENT_TIMESTAMP()  into @endTime;

 

end
//
DELIMITER ;