mysql批量插入定时器

来源：互联网发布：javascript 执行顺序编辑：程序博客网时间：2024/05/24 00:00

delimiter $$；
create event release_securitiesnum
#on schedule every 1 day starts timestamp '2016-11-16 12:00:00'
on schedule every 2 SECOND
do
begin
#批量插入
insert into zxzq_drawcash_record (status ,memberid , releasenum, securitiesnum, securitiesnum_after, time, securitiesid)
select 2 , memberid ,TRUNCATE(securitiesnum * 0.001,2), securitiesnum , TRUNCATE(securitiesnum - TRUNCATE(securitiesnum * 0.001,2),2), NOW(), securitiesid from zxzq_holding;

#存在更新，不存在插入
replace into zxzq_drawcash(memberid, securitiesnum) select h.memberid, TRUNCATE(sum(h.securitiesnum)*0.001 + d.securitiesnum,2)
from zxzq_holding h LEFT JOIN zxzq_drawcash d on d.memberid = h.memberid group by h.memberid;

update zxzq_holding set securitiesnum = TRUNCATE(securitiesnum * 0.999,2);

end $$

这里有一个例子，可以参考一下：http://www.oschina.net/question/4873_20927

0 0