aHMAD_SQaLli Posted December 4, 2015 Share Posted December 4, 2015 Hello I want to make a SQL row to be deleted after one day, or week, or every row older than on week automatically, how can it be done ? Have a good day. Link to comment https://forums.phpfreaks.com/topic/299643-delete-a-sql-row-after-a-week/ Share on other sites More sharing options...
Barand Posted December 4, 2015 Share Posted December 4, 2015 Assuming your table has a date column DELETE FROM tablename WHERE date_col < CURDATE() - INTERVAL 7 DAY Link to comment https://forums.phpfreaks.com/topic/299643-delete-a-sql-row-after-a-week/#findComment-1527549 Share on other sites More sharing options...
aHMAD_SQaLli Posted December 4, 2015 Author Share Posted December 4, 2015 Thanks, that was helpful, but I should run this manually, is there any way to be 100% auto . Link to comment https://forums.phpfreaks.com/topic/299643-delete-a-sql-row-after-a-week/#findComment-1527550 Share on other sites More sharing options...
Barand Posted December 4, 2015 Share Posted December 4, 2015 You would use Windows Scheduler or a cron job (linux) to invoke the query. Link to comment https://forums.phpfreaks.com/topic/299643-delete-a-sql-row-after-a-week/#findComment-1527551 Share on other sites More sharing options...
aHMAD_SQaLli Posted December 4, 2015 Author Share Posted December 4, 2015 Thank you very much ! Link to comment https://forums.phpfreaks.com/topic/299643-delete-a-sql-row-after-a-week/#findComment-1527554 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.