DELIMETER $$ CREATE EVENT loan_balance ON SCHEDULE EVERY '1' MONTH AND '5' DAYS DO BEGIN UPDATE users SET loan_balance = total_loans_collected - total_loans_paid; END$$ DELIMETER;
你好!我想在每个月的5号更新这个表,而不仅仅是每月一次。“和”5“天没用。
