mysql 定时执行
首先,这个功能只能在5.1.X之上才能用
CREATE TABLE tab1( tab1_id varchar(11), num int);DELIMITER //CREATE EVENT e_hourlyON SCHEDULEEVERY 1 MINUTECOMMENT 'Clears out sessions table each hour.'DOBEGIN-- DELETE FROM site_activity.sessions;update tab1 set num=num+1 WHERE tab1_id='sdfsd';END;