use mydb;
alter EVENT expireRow
ON SCHEDULE
EVERY 1 HOUR
DO
DELETE FROM thatTable
WHERE TIMESTAMPDIFF(DAY, date , NOW()) > 7
==
SHOW EVENTS FROM mydb;
'mysql' 카테고리의 다른 글
connection, cursor, transaction 사용시 주의점 (0) | 2015.02.04 |
---|
use mydb;
alter EVENT expireRow
ON SCHEDULE
EVERY 1 HOUR
DO
DELETE FROM thatTable
WHERE TIMESTAMPDIFF(DAY, date , NOW()) > 7
==
SHOW EVENTS FROM mydb;
connection, cursor, transaction 사용시 주의점 (0) | 2015.02.04 |
---|