Ask your bosses, mysql Settings, perform a other functions to the end of each month how to write

CodePudding user response:

The CREATE EVENT ` event_name `
ON the SCHEDULE EVERY MONTH 1
STARTS '2021-03-31 00:00:00 ON COMPLETION PRESERVE
The ENABLE
DO call pro_name;

Event_name: is what you create event name
Pro_name: is the function you want to perform a monthly
Starts: what time is from beginning

CodePudding user response:

reference 1/f, the breeze gently up response:

CREATE EVENT ` event_name `
ON the SCHEDULE EVERY MONTH 1
STARTS '2021-03-31 00:00:00 ON COMPLETION PRESERVE
The ENABLE
DO call pro_name;

Event_name: is what you create event name
Pro_name: is the function you want to perform a monthly
Starts: what time is from start

If it is in February, also will perform?

CodePudding user response:

Starts the date, after the day of each month, will be performed

CodePudding user response:

refer to the 4th floor breeze gently up response:

starts date, after the day of each month, will perform

So I just want to ask whether in February when performing, because February 20 days