[Solved] Delete row if key code is there for more than 15 min

Register Sign In

[Solved] Delete row if key code is there for more than 15 min

Diederik
Senior Member
Posts: 299
Threads: 0
Joined: Jan 2015
Reputation: 20

#3

02-05-2017, 03:29 AM

Just perform a single sql

Code:
DELETE FROM post

WHERE date_modifieda < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 15 MINUTE))

Messages In This Thread

[Solved] Delete row if key code is there for more than 15 min - by wolfgang1983 - 02-05-2017, 12:42 AM

RE: Delete row if key code is there for more than 15 min - by casa - 02-05-2017, 03:25 AM

RE: Delete row if key code is there for more than 15 min - by Diederik - 02-05-2017, 03:29 AM

RE: Delete row if key code is there for more than 15 min - by wolfgang1983 - 02-05-2017, 10:37 PM

RE: Delete row if key code is there for more than 15 min - by Wouter60 - 02-05-2017, 11:57 PM

RE: Delete row if key code is there for more than 15 min - by wolfgang1983 - 02-06-2017, 06:01 PM

RE: Delete row if key code is there for more than 15 min - by Wouter60 - 02-06-2017, 11:04 PM

RE: Delete row if key code is there for more than 15 min - by wolfgang1983 - 02-07-2017, 01:06 AM

RE: [Solved] Delete row if key code is there for more than 15 min - by Wouter60 - 02-07-2017, 02:35 PM

Theme © iAndrew 2016 - Forum software by © MyBB