delete a SQL row after a week

[aHMAD_SQaLli 0]

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.

[Barand 1,398]

Assuming your table has a date column

DELETE FROM tablename WHERE date_col < CURDATE() - INTERVAL 7 DAY

[aHMAD_SQaLli 0]

Thanks, that was helpful, but I should run this manually, is there any way to be 100% auto .

[Barand 1,398]

You would use Windows Scheduler or a cron job (linux) to invoke the query.

[aHMAD_SQaLli 0]

Thank you very much !