CREATE EVENT `clean_321taxi messages` ON SCHEDULE EVERY 1 DAY STARTS '2012-12-13 03:00:00' DO BEGIN DELETE FROM 321taxi.message_log WHERE timestamp < DATE_SUB(NOW(),INTERVAL 30 DAY) and EntityID <> 0; END