delete sql row automatically after one hour

Question

I have 2 forums in forum 1 the user insert into table some data and in one of column "result" he insert "processing" in forum 2 he update that column to "succeed" what i want to do is if the column stays "processing" (which means the user did not do forum 2 ) for one hour it get automatically deleted after one hour.

[You're looking for a cron job](http://stackoverflow.com/questions/18737407/how-to-create-cron-job-using-php). — Andrei, Jul 15 '15 at 13:48
thanks i think thats it,i have to run a php code that it delete it everyone one hour,i will look it up — Zouaoui Djaballah, Jul 15 '15 at 13:55

score 0 · Accepted Answer · edited Jul 19 '15 at 22:05

0

You can create MySQL event scheduler.

http://www.sitepoint.com/how-to-create-mysql-events/

edited Jul 19 '15 at 22:05

halfer

19,824
17
99
186

answered Jul 15 '15 at 13:57

Ganesan Karuppasamy

322
2
8

i believe this is better than cron job i will look it up thanks – Zouaoui Djaballah Jul 15 '15 at 14:01

delete sql row automatically after one hour

1 Answers1