Wondering if its possible to have a file running and checking if a value in database/row

Question

Basically, If a value in Row is same for 3 days I want to remove the column, like if someone hasn't verified their account remove the account to save space.

Is there a way to make a script for this? If so can someone help me make it?

are you using a linux system? – anurupr Feb 13 '14 at 10:38 — anurupr, Feb 13 '14 at 10:38
you want to remove a column, not a row? – Barmar Feb 13 '14 at 10:43 — Barmar, Feb 13 '14 at 10:43

score 0 · Answer 1 · answered Feb 13 '14 at 10:42

0

Have a column like

modified timestamp default current_timestamp on update current_timestamp

in your table. Then write a query to delete entries of the table and execute it via event scheduler.

answered Feb 13 '14 at 10:42

fancyPants

50,732
33
89
96

score 0 · Answer 2 · edited May 23 '17 at 12:29

0

You can setup a cron job to run every day and execute this query on the database:

DELETE FROM table WHERE insert_date BETWEEN DATE_SUB(NOW(), INTERVAL 3 DAY) AND NOW();

Note: similar problem here.

edited May 23 '17 at 12:29

Community

1
1

answered Feb 13 '14 at 10:55

Wilmer

448
2
4

Wondering if its possible to have a file running and checking if a value in database/row

2 Answers2