mysql
Making scheduler for expiry
시간을 거스르는자
2018. 1. 19. 16:37
use mydb;
alter EVENT expireRow
ON SCHEDULE
EVERY 1 HOUR
DO
DELETE FROM thatTable
WHERE TIMESTAMPDIFF(DAY, date , NOW()) > 7
==
SHOW EVENTS FROM mydb;