DELIMITER $$
CREATE /*[DEFINER = { user | CURRENT_USER }]*/ EVENT `dev_sp2p6`.`e_test1`
ON SCHEDULE
EVERY 1 MONTH
STARTS DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH),INTERVAL 0 HOUR)
ON COMPLETION PRESERVE
ENABLE
DO
BEGIN
INSERT INTO mdz_user(NAME,age) VALUES(‘dezhou’,18);
END$$
DELIMITER ;