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 ;