MYSQL bazanizdaki cedvelden ayliq melumat temizleme

DELETE FROM Cedvel_adi
WHERE datanizin_tarix_columname-i < DATE_SUB(NOW(), INTERVAL 1 MONTH);

Ve ya MySQL Event Scheduler istifade ede bilersiniz ;)

SET GLOBAL event_scheduler = ON;

DELIMITER $$

CREATE EVENT clearLog
ON SCHEDULE EVERY ‘1’ MONTH
STARTS ‘2011-05-01 00:00:00′
DO
BEGIN
DELETE FROM Cedvel_adi WHERE datanizin_tarix_columname-i < DATE_SUB(NOW(), INTERVAL 1 MONTH);
END$$

DELIMITER ;