Deleting records before a certain date

Question

How would I go about deleting all records from a MySQL table from before a certain date  where the date column is in DATETIME format   An example datetime is 2011-09-21 08 21 22

User · Answer

To show result till yesterday  WHERE DATE date time   lt  CURDATE     To show results of 10 days  WHERE date time  lt  NOW   - INTERVAL 10 DAY   To show results before 10 days  WHERE DATE date time   lt  DATE NOW   - INTERVAL 10 DAY    These will work for you  You can find dates like this   SELECT DATE NOW   - INTERVAL 11 DAY

User · Answer

This helped me delete data based on different attributes  This is dangerous so make sure you back up database or the table before doing it   mysqldump -h hotsname -u username -p password database name  gt  backup folder backup filename txt   Now you can perform the delete operation   delete from table name where column name  lt  DATE SUB NOW     INTERVAL 1 DAY    This will remove all the data from before one day  For deleting data from before 6 months   delete from table name where column name  lt  DATE SUB NOW     INTERVAL 6 MONTH

User · Answer

This is another example using defined column table names  DELETE FROM jos jomres gdpr optins WHERE  date time   lt   2020-10-21 08 21 22

User · Answer

DELETE FROM table WHERE date  lt   2011-09-21 08 21 22

[mysql] Deleting records before a certain date

Examples related to mysql

Examples related to datetime

Examples related to delete-row