개발도구/SQL, Query, Cloud
[SQL] 지난 기간의 데이터를 삭제하기
Hay's App
2011. 9. 26. 09:43
$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);