I was provided this script some time ago (below). I run in MyPhpAdmin, but get error and 0 rows affected. Is something missing from the sql string?
delete from tc_positions where servertime < DATE(NOW() - INTERVAL 180 day)
delete from tc_statistics where capturetime < DATE(NOW() - INTERVAL 180 day)
delete from tc_events where servertime < DATE(NOW() - INTERVAL 180 day)
I was provided this script some time ago (below). I run in MyPhpAdmin, but get error and 0 rows affected. Is something missing from the sql string?
delete from tc_positions where servertime < DATE(NOW() - INTERVAL 180 day) delete from tc_statistics where capturetime < DATE(NOW() - INTERVAL 180 day) delete from tc_events where servertime < DATE(NOW() - INTERVAL 180 day)