MySQL
MySQL

Work with records older then x days

For the sake of this example, let’s assume that: we want to work with records older then 60 days the table name is ‘table’ (how original!) the table field with dates is called date_field 🙂 DELETE FROM table WHERE date_field < DATE_SUB(CURDATE(),INTERVAL 60 DAY) This MySQL command deletes all table […]