Comments by Channa Senevirathne Bandara (Top 1 by date)

thank your advice i created this Solution

<pre lang="SQL">CREATE DEFINER=`root`@`localhost` EVENT `OfferDetailTable` ON SCHEDULE EVERY 1 DAY STARTS '2013-10-16 15:54:07' ON COMPLETION NOT PRESERVE ENABLE DO DELETE FROM Offer_detail
WHERE offer_to < DATE_SUB(NOW(), INTERVAL 1 DAY)</pre>