自动删除旧数据

Question

I have a table in which I would like the old data to be deleted automatically if the time is older than 5 days. The table looks like this : http://de.share-your-photo.com/e6508ee7a6. Can someone help me? The below Code does not work

<?php
require_once __DIR__ . '/connection.php';
$variants_remove='DELETE FROM drucker AS drucker WHERE datediff(now(), drucker.zeit) > 5';
$req = $dbConnect->query($variants_remove);
?>

Answer 1

Change to

WHERE drucker.zeit) < NOW() - INTERVAL 5 DAY

You could use CURDATE() instead of NOW() if you prefer to backup from midnight this morning.