按照update_tiem字段删除過期數據
use test_db;
delimiter //
create procedure dele_src_data()
begin
DELETE FROM src_data where TO_DAYS(now())-TO_DAYS(update_time) > 1;
end//
delimiter ;c定時器
create event del_src_data
on schedule EVERY 3 day
on completion preserve enable
do call dele_src_data();
如果需要指定執行開始和結束時間如下：
每隔10分鐘執行一次，如下：
DROP event dele_src_data
show events
select * from mysql.event;
SHOW create EVENT del_src_data
show variables like 'event_scheduler';
set global event_scheduler=on;
永久開啟事件：
在my.ini配置文件的[mysqld]部分，加上event_scheduler=ON 即可。
顯示事件的運行狀态
show processlist;
alter event del_src_data on completion preserve enable;
alter event del_src_data on completion preserve disable;
更多精彩资讯请关注tft每日頭條，我们将持续为您更新最新资讯!
zpostcode 
Recruit 
weather 
mreligion 
Yellowpages 
sport 
constellation 
shopping 
name 
game 
directory 
literature 
Word 
tour 
furnish 
Lottery 
tftnews 
lyrics 
News 
digital 
car 
dir 
Edu 
Finance 
