Re: MySQL Events: How to schedule commands for every 1st day of the month?

[Cesar Murilo Cesar]

Does this event below not work?

CREATE EVENT ev_radacct_cpmonth EVERY MONTH
DO
START TRANSACTION;
SET @radacct_pmonth:=(SELECT CONCAT('radacct_',YEAR(NOW()),MONTH(NOW())-1) AS radacct_pmonth);
CREATE TABLE IF NOT EXISTS @radacct_pmonth SELECT * FROM RADACCT;
DELETE FROM radius.radacct WHERE accstoptime < date_sub(NOW(),INTERVAL 1 MONTH);
OPTIMIZE radius.raddacct;
COMMIT;

I will test the commands yet. I'm new to MySQL and I have this difficult mission in the company. Please help me, please.