1.查看 show variables like '%event_sche%';
2.开启 set global event_scheduler=1;
3.创建存储过程
use XXX; #使用XXX数据库
delimiter //
create procedure tongji_event_count()
begin
insert into `tongji_event`(`eventId`,`count`,`date`)
(select eventId as eventId ,
sum(value) as count,
DATE_FORMAT(NOW(),'%Y-%m-%d') as date
from ad.record_event
where DATE_FORMAT(createTime,'%Y-%m-%d')=DATE_FORMAT(NOW(),'%Y-%m-%d')
group by eventId )
ON DUPLICATE KEY UPDATE count= values(count);
end//
delimiter ;
4.查看存储过程
select `name` from mysql.proc where db = 'XXX' and `type` = 'PROCEDURE';
(创建错了如何删除,删除存储过程 drop p