文章标题

最新推荐文章于 2024-09-15 08:03:51 发布

qq_15139393

最新推荐文章于 2024-09-15 08:03:51 发布

阅读量418

点赞数

分类专栏： mysql-job 文章标签： server 数据库 mysql

mysql-job 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

/*
Navicat MySQL Data Transfer

Source Server : activiti
Source Server Version : 50624
Source Host : localhost:3306
Source Database : job

Target Server Type : MYSQL
Target Server Version : 50624
File Encoding : 65001

Date: 2016-08-27 15:19:25
*/

SET FOREIGN_KEY_CHECKS=0;

– Table structure for info

DROP TABLE IF EXISTS info;
CREATE TABLE info (
id int(11) NOT NULL DEFAULT ‘0’,
time datetime DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

– Records of info

INSERT INTO info VALUES (‘1’, ‘2016-08-27 15:19:17’);

– Procedure structure for test

DROP PROCEDURE IF EXISTS test;
DELIMITER ;;
CREATE DEFINER=root@localhost PROCEDURE test()
BEGIN
update info SET time = now() WHERE id = 1;
END
;;
DELIMITER ;

– Event structure for e_test

DROP EVENT IF EXISTS e_test;
DELIMITER ;;
CREATE DEFINER=root@localhost EVENT e_test ON SCHEDULE EVERY 10 SECOND STARTS ‘2016-08-27 15:05:57’ ON COMPLETION PRESERVE ENABLE DO call test()
;;
DELIMITER ;