DROP TABLE IF EXISTS `test_sche`;
CREATE TABLE `test_sche` (
  `id` int(11) NOT NULL,
  `counts` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of test_sche
-- ----------------------------
INSERT INTO `test_sche` VALUES ('1', '188');

CREATE DEFINER=`root`@`localhost` PROCEDURE `add`()
BEGIN
	#Routine body goes here...

UPDATE test_sche SET counts=counts+1 WHERE id=1;
END

-- 设置分隔符为 '$$' ，mysql默认的语句分隔符为 ';' ，这样在后续的 create 到 end 这段代码都会看成是一条语句来执行  
DELIMITER $$  

//创建存储过程或者事件语句


//结束
$$
- 将语句分割符设置回 ';'  
DELIMITER ; 

CREATE DEFINER=`root`@`localhost` EVENT `test_sche_event` 
ON SCHEDULE EVERY 5 SECOND STARTS '2016-07-12 22:11:50' 
ON COMPLETION NOT PRESERVE ENABLE 
DO CALL `add`

set GLOBAL event_scheduler = 1;  

select * from mysql.event  

ALTER EVENT test_sche_event DISABLE;


ALTER EVENT test_sche_event ENABLE;