mysql 存储过程（proceduce）查询一个表的结果插入另外一个表

procedure record_timestamp_deal ; ##创建存储过程 create procedure record_timestamp_deal() begin declare tslogId varchar(50); declare done int default 0; # declare existence boolean ; ##从时间戳记录表中获取ID存入游标 declare cur cursor for select id from time_stamp_log; ##异常处理 declare continue handler for sqlstate ‘02000‘ set done = 1; open cur; ##取出游标值至变量中 fetch next from cur into tslogId; repeat if not done then #查询时间戳待记录id是否在时间戳待存证表 if (select * from osv_timestamp_evi_prepare where timestampId = tslogId) is not null then ##不存在的记录写入待存证表 insert into osv_timestamp_evi_prepare(timestampId,createTime) values(tslogId,now()); end if; end if; ##重新抓取数据进入循环 fetch next from cur into tslogId; ##结束循环 until done end repeat; ##关闭游标 close cur; end ; call record_timestamp_deal();

 

mysql 存储过程（proceduce）查询一个表的结果插入另外一个表

标签：weight   span   sel   业务   抓取   handle   pid   handler   close