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 |
|---|
시간을 거스르는자
ytkang86@gmail.com