MySql Event to Delete Data from 2 Tables Older Than 2 Months
When you have multiple statements you need not only a BEGIN and END
But also a DELIMITER
One error is also dates have to be in quotes as you can see in the code
DELIMITER //
CREATE EVENT 
IF NOT EXISTS daily_delete 
ON SCHEDULE EVERY 1 DAY STARTS '020-09-13 04:00:00' 
DO 
BEGIN 
    DELETE 
    FROM bariq_DB.invoice 
    where timestampdiff(MONTH,created_at,NOW()) &gt; 2 and payment_status = 2; 
    delete from bariq_DB.order_details 
    where timestampdiff(MONTH,created_at,NOW()) &gt; 2 and payment_status = 3; 
END;//
DELIMITER ;