본문 바로가기

개발도구/SQL, Query, Cloud

[SQL] 지난 기간의 데이터를 삭제하기

$query = "DELETE  FROM table WHERE cronDate < DATE_ADD(NOW(),INTERVAL -2 DAY)";
sql_query($query);

$query = "DELETE  FROM table WHERE cronDate < DATE_ADD(NOW(),INTERVAL -10 DAY)";
sql_query($query);

$query = "DELETE  FROM table WHERE cronDate < DATE_ADD(NOW(),INTERVAL -2 DAY)";
sql_query($query);