========================================================== * 2015-06-22 SELECT * FROM `nent` WHERE (dt_create < '2015-03-01') DELETE FROM `nent` WHERE (dt_create < '2015-03-01') SELECT * FROM `fc2` WHERE (dt_create < '2015-04-01') DELETE FROM `fc2` WHERE (dt_create < '2015-04-01') ========================================================== * 2015-07-01 SELECT * FROM `nent` WHERE (dt_create < '2015-03-15') DELETE FROM `nent` WHERE (dt_create < '2015-03-15') ========================================================== * 2015-07-10 Delete 15days : 2015-04-01 --- 2015-04-15 SELECT * FROM `fc2` WHERE (dt_create < '2015-04-15') ==> 21051 DELETE FROM `fc2` WHERE (dt_create < '2015-04-15') Delete 15days : 2015-03-15 --- 2015-04-01 SELECT * FROM `nent` WHERE (dt_create < '2015-04-01') ==> 44278 DELETE FROM `nent` WHERE (dt_create < '2015-04-01') ========================================================== * 2015-07-25 Delete 15days : 2015-04-15 --- 2015-05-01 SELECT * FROM `fc2` WHERE (dt_create < '2015-05-01') ==> 24210 DELETE FROM `fc2` WHERE (dt_create < '2015-05-01') ========================================================== * 2015-07-27 Delete 15days : 2015-04-01 --- 2015-04-15 SELECT * FROM `nent` WHERE (dt_create < '2015-04-15') ==> 34786 DELETE FROM `nent` WHERE (dt_create < '2015-04-15') ========================================================== * 2015-08-05 Delete 15days : 2015-05-01 --- 2015-05-15 SELECT * FROM `fc2` WHERE (dt_create < '2015-05-15') ==> 22781 DELETE FROM `fc2` WHERE (dt_create < '2015-05-15') Delete 15days : 2015-04-15 --- 2015-05-01 SELECT * FROM `nent` WHERE (dt_create < '2015-05-01') ==> 43204 DELETE FROM `nent` WHERE (dt_create < '2015-05-01') ========================================================== * 2015-08-23 Delete 15days : 2015-05-15 --- 2015-06-01 SELECT * FROM `fc2` WHERE (dt_create < '2015-06-01') ==> 23404 DELETE FROM `fc2` WHERE (dt_create < '2015-06-01') Delete 15days : 2015-05-01 --- 2015-05-15 SELECT * FROM `nent` WHERE (dt_create < '2015-05-15') ==> 43746 DELETE FROM `nent` WHERE (dt_create < '2015-05-15') ========================================================== * 2015-09-08 Delete 15days : 2015-06-01 --- 2015-06-08 SELECT * FROM `fc2` WHERE (dt_create < '2015-06-08') ==> 7943 DELETE FROM `fc2` WHERE (dt_create < '2015-06-08') Delete 15days : 2015-05-15 --- 2015-06-01 SELECT * FROM `nent` WHERE (dt_create < '2015-06-01') ==> 41540 DELETE FROM `nent` WHERE (dt_create < '2015-06-01') ========================================================== * 2015-09-12 Delete 15days : 2015-06-18 --- 2015-06-23 SELECT * FROM `fc2` WHERE (dt_create < '2015-06-23') ==> 14110 DELETE FROM `fc2` WHERE (dt_create < '2015-06-23') ========================================================== * 2015-11-26 Delete 15days : 2015-06-23 --- 2015-07-15 SELECT * FROM `fc2` WHERE (dt_create < '2015-07-15') ==> 36200 DELETE FROM `fc2` WHERE (dt_create < '2015-07-15') ========================================================== * 2016-02-14 Delete 30days : 2015-07-15 --- 2015-08-15 SELECT * FROM `fc2` WHERE (dt_create < '2015-08-15') ==> 48699 DELETE FROM `fc2` WHERE (dt_create < '2015-08-15')