Delete records in MySQL from the bmh_actionscheduler_logs table where the log_date_gmt is before a specific date

To delete records in MySQL from the bmh_actionscheduler_logs table where the log_date_gmt is before a specific date and time (2024-12-02 14:11:20), you can execute the following SQL query:

Verify Deletion:

SELECT * FROM bmh_actionscheduler_logs
WHERE log_date_gmt < ‘2024-12-02 14:11:20’;

Delete all:

DELETE FROM bmh_actionscheduler_logs;

    
DELETE FROM bmh_actionscheduler_logs WHERE log_date_gmt < '2024-12-02 14:11:20';

Leave a Reply