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;