MySql每日删除表中数据

-- ----------------------------
-- Procedure structure for `traffic_event_history_day`
-- 创建一个存储过程，存储过程中执行删除数据
-- ----------------------------
DROP PROCEDURE IF EXISTS `traffic_event_history_day`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `traffic_event_history_day`
(
)
BEGIN  
	delete from traffic_event_history Where TimeStampDiff(Month ,InsertDate,NOW()) >=3;
  END
;;
DELIMITER ;




-- ----------------------------
-- Event structure for `traffic_event_history_day`
-- 创建一个事件，计划每日执行，每日调用执行上面那个存储过程
-- ----------------------------
DROP EVENT IF EXISTS `traffic_event_history_day`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` EVENT `traffic_event_history_day` ON SCHEDULE EVERY 1 DAY STARTS '2014-05-01 00:10:00' ON COMPLETION NOT PRESERVE ENABLE DO CALL traffic_event_history_day
;;
DELIMITER ;