mysql 创建事件_mysql 5.1 创建事件

最新推荐文章于 2024-04-20 03:00:00 发布
最新推荐文章于 2024-04-20 03:00:00 发布
阅读量437 收藏
点赞数 1
文章标签： mysql 创建事件
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_42613773/article/details/114332048
版权

创建事件(CREATE EVENT)

先来看一下它的语法：

CREATE EVENT [IF NOT EXISTS] event_name

ON SCHEDULE schedule

[ON COMPLETION [NOT] PRESERVE]

[ENABLE | DISABLE]

[COMMENT 'comment']

DO sql_statement;

schedule:

AT TIMESTAMP [+ INTERVAL INTERVAL]

| EVERY INTERVAL [STARTS TIMESTAMP] [ENDS TIMESTAMP]

INTERVAL:

quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |

WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |

DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}

1) 首先来看一个简单的例子来演示每秒插入一条记录到数据表

USE test;

CREATE TABLE aaa (timeline TIMESTAMP);

CREATE EVENT e_test_insert

ON SCHEDULE EVERY 1 SECOND

DO INSERT INTO test.aaa VALUES (CURRENT_TIMESTAMP);

等待3秒钟后，再执行查询看看：

mysql> SELECT * FROM aaa;

+---------------------+

| timeline |

+---------------------+

| 2007-07-18 20:44:26 |

| 2007-07-18 20:44:27 |

| 2007-07-18 20:44:28 |

+---------------------+

2) 5天后清空test表：

CREATE EVENT e_test

ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 5 DAY

DO TRUNCATE TABLE test.aaa;

3) 2007年7月20日12点整清空test表：

CREATE EVENT e_test

ON SCHEDULE AT TIMESTAMP '2007-07-20 12:00:00'

DO TRUNCATE TABLE test.aaa;

4) 每天定时清空test表：

CREATE EVENT e_test

ON SCHEDULE EVERY 1 DAY

DO TRUNCATE TABLE test.aaa;

5) 5天后开启每天定时清空test表：

CREATE EVENT e_test

ON SCHEDULE EVERY 1 DAY

STARTS CURRENT_TIMESTAMP + INTERVAL 5 DAY

DO TRUNCATE TABLE test.aaa;

6) 每天定时清空test表，5天后停止执行：

CREATE EVENT e_test

ON SCHEDULE EVERY 1 DAY

ENDS CURRENT_TIMESTAMP + INTERVAL 5 DAY

DO TRUNCATE TABLE test.aaa;

7) 5天后开启每天定时清空test表，一个月后停止执行：

CREATE EVENT e_test

ON SCHEDULE EVERY 1 DAY

STARTS CURRENT_TIMESTAMP + INTERVAL 5 DAY

ENDS CURRENT_TIMESTAMP + INTERVAL 1 MONTH

DO TRUNCATE TABLE test.aaa;

[ON COMPLETION [NOT] PRESERVE]可以设置这个事件是执行一次还是持久执行，默认为NOT PRESERVE。

8) 每天定时清空test表(只执行一次，任务完成后就终止该事件)：

CREATE EVENT e_test

ON SCHEDULE EVERY 1 DAY

ON COMPLETION NOT PRESERVE

DO TRUNCATE TABLE test.aaa;

[ENABLE | DISABLE]可是设置该事件创建后状态是否开启或关闭，默认为ENABLE。

[COMMENT ‘comment’]可以给该事件加上注释。

三、修改事件(ALTER EVENT)

ALTER EVENT event_name

[ON SCHEDULE schedule]

[RENAME TO new_event_name]

[ON COMPLETION [NOT] PRESERVE]

[COMMENT 'comment']

[ENABLE | DISABLE]

[DO sql_statement]

1) 临时关闭事件

ALTER EVENT e_test DISABLE;

2) 开启事件

ALTER EVENT e_test ENABLE;

3) 将每天清空test表改为5天清空一次：

ALTER EVENT e_test

ON SCHEDULE EVERY 5 DAY;

四、删除事件(DROP EVENT)

语法很简单，如下所示：

DROP EVENT [IF EXISTS] event_name

例如删除前面创建的e_test事件

DROP EVENT e_test;

当然前提是这个事件存在，否则会产生ERROR 1513 (HY000): Unknown event错误，因此最好加上IF EXISTS

DROP EVENT IF EXISTS e_test;

定时任务

查看event是否开启: show variables like '%sche%';

将事件计划开启: set global event_scheduler=1;

关闭事件任务: alter event e_test ON COMPLETION PRESERVE DISABLE;

开户事件任务: alter event e_test ON COMPLETION PRESERVE ENABLE;

简单实例.

创建表 CREATE TABLE test(endtime DATETIME);

创建存储过程test

CREATE PROCEDURE test ()

BEGIN

update examinfo SET endtime = now() WHERE id = 14;

END;

创建event e_test

CREATE EVENT if not exists e_test

on schedule every 30 second

on completion preserve

do call test();

每隔30秒将执行存储过程test,将当前时间更新到examinfo表中id=14的记录的endtime字段中去.

触发器

delimiter //

CREATE TRIGGER trigger_htmlcache BEFORE INSERT ON t_model

FOR EACH ROW BEGIN

if CURDATE()

INSERT INTO t_htmlcache(id,url) value(NEW.id,NEW.url);

end if;

END;

//

通过建表->Insert的方式测试.

DELIMITER $$

DROP PROCEDURE IF EXISTS `njfyedepartment`.`sp_ireport` $$

CREATE DEFINER=`root`@`%` PROCEDURE `sp_ireport`(IN qureyType VARCHAR(20),IN daytime VARCHAR(20),IN p_ids VARCHAR(50),IN c_ids VARCHAR(50),IN ct1_ids VARCHAR(50),IN ct2_ids VARCHAR(50),IN ku VARCHAR(50),IN ireport_chart varchar(50))

BEGIN

DECLARE i INT DEFAULT 1;

IF qureyType  = 'insert' OR qureyType  = 'INSERT' THEN

INSERT INTO ireport

(pid,cid,ct1id,ct2id,creatTime,crawlerNumber,WEEK)

SELECT province AS pid,

cityid AS cid,

category1id AS ct1id,

category2id AS ct2id,

(CURRENT_DATE) AS creatTime,COUNT(*) AS crawlerNumber,

(FLOOR(DAYOFMONTH(CURRENT_DATE)/8)+1) AS WEEK

FROM t_model t

WHERE TIME > (CURRENT_DATE-1) AND TIME < (CURRENT_DATE)

AND province IS NOT NULL

AND cityid IS NOT NULL

GROUP BY province,cityid,category1id,category2id;

END IF;

IF qureyType  = 'month' OR qureyType  = 'MONTH' THEN

IF EXISTS(SELECT * FROM information_schema.`TABLES` T WHERE TABLE_NAME = 'tmp_result' AND TABLE_SCHEMA = ku) THEN

DROP TABLE tmp_result;

END IF;

CREATE TABLE tmp_result

(pid VARCHAR(50),pName VARCHAR(50),cid VARCHAR(50),cName VARCHAR(50),ct1id VARCHAR(50),ct1Name VARCHAR(50),

ct2id VARCHAR(50),ct2Name VARCHAR(50),month1 INTEGER,month2 INTEGER,month3 INTEGER,month4 INTEGER,month5 INTEGER,

month6 INTEGER,month7 INTEGER,month8 INTEGER,month9 INTEGER,month10 INTEGER,month11 INTEGER,month12 INTEGER,heji INTEGER);

lable_exit: BEGIN

SET @SqlCmd = ' INSERT INTO tmp_result (pid,pname,cid,cname,ct1id,ct1name,ct2id,ct2name)

SELECT pid,pname,cid,cname,ct1id,ct1name,ct2id,ct2name FROM

(SELECT ia.pid,a.name AS pname,ia.cid,b.name AS cname,ia.ct1id,c.name AS ct1name,ia.ct2id,d.name AS ct2name

FROM ireport ia

LEFT JOIN province a ON ia.pid=a.id

LEFT JOIN city b ON ia.cid=b.id

LEFT JOIN t_category1 c ON ia.ct1id=c.id

LEFT JOIN t_category2 d ON ia.ct2id=d.id

WHERE YEAR(ia.creatTime)=YEAR(?) ';

IF p_ids IS NOT NULL AND p_ids <> '' THEN

SET @SqlCmd = CONCAT(@SqlCmd , 'and ia.pid in (');

SET @SqlCmd = CONCAT(@SqlCmd, p_ids);

SET @SqlCmd = CONCAT(@SqlCmd, ')');

END IF;

IF c_ids IS NOT NULL AND c_ids <> '' THEN

SET @SqlCmd = CONCAT(@SqlCmd , 'and ia.cid in (');

SET @SqlCmd = CONCAT(@SqlCmd, c_ids);

SET @SqlCmd = CONCAT(@SqlCmd, ')');

END IF;

IF ct1_ids IS NOT NULL AND ct1_ids <> '' THEN

SET @SqlCmd = CONCAT(@SqlCmd , 'and ia.ct1id in (');

SET @SqlCmd = CONCAT(@SqlCmd, ct1_ids);

SET @SqlCmd = CONCAT(@SqlCmd, ')');

END IF;

IF ct2_ids IS NOT NULL AND ct2_ids <> '' THEN

SET @SqlCmd = CONCAT(@SqlCmd , 'and ia.ct2id in (');

SET @SqlCmd = CONCAT(@SqlCmd, ct2_ids);

SET @SqlCmd = CONCAT(@SqlCmd, ')');

END IF;

SET @SqlCmd = CONCAT(@SqlCmd , ') AS ir GROUP BY pid,pname,cid,cname,ct1id,ct1name,ct2id,ct2name;');

PREPARE stmt1 FROM @SqlCmd;

SET @a = daytime;

EXECUTE stmt1 USING @a;

DEALLOCATE PREPARE stmt1;

LEAVE lable_exit;

END lable_exit;

WHILE i <= 12 DO

lable_exit: BEGIN

SET @SqlCmd = 'UPDATE tmp_result AS a,

(

SELECT pid,cid,ct1id,ct2id,SUM(crawlerNumber) AS crawlerNumber FROM

(SELECT pid,cid,ct1id,ct2id,crawlerNumber FROM ireport WHERE MONTH(creatTime)=? AND YEAR(creatTime)=YEAR(?)) AS ir

GROUP BY pid,cid,ct1id,ct2id

) AS b

SET a.month';

SET @SqlCmd = CONCAT(@SqlCmd , i);

SET @SqlCmd = CONCAT(@SqlCmd , '=b.crawlerNumber ');

SET @SqlCmd = CONCAT(@SqlCmd , 'WHERE a.pid=b.pid AND a.cid=b.cid AND a.ct1id=b.ct1id AND a.ct2id=b.ct2id; ');

PREPARE stmt1 FROM @SqlCmd;

SET @a = i;

SET @b = daytime;

EXECUTE stmt1 USING @a,@b;

DEALLOCATE PREPARE stmt1;

LEAVE lable_exit;

END lable_exit;

lable_exit: BEGIN

SET @SqlCmd = 'UPDATE tmp_result SET month';

SET @SqlCmd = CONCAT(@SqlCmd , i);

SET @SqlCmd = CONCAT(@SqlCmd , ' = 0 WHERE month');

SET @SqlCmd = CONCAT(@SqlCmd , i);

SET @SqlCmd = CONCAT(@SqlCmd , ' IS NULL');

PREPARE stmt1 FROM @SqlCmd;

EXECUTE stmt1;

DEALLOCATE PREPARE stmt1;

LEAVE lable_exit;

END lable_exit;

SET i = i + 1;

END WHILE;

UPDATE tmp_result SET heji=month1+month2+month3+month4+month5+month6+month7+month8+month9+month10+month11+month12;

INSERT INTO tmp_result (pid,pname,cid,cname,ct1id,ct1name,ct2id,ct2name,month1,month2,month3,month4,month5,month6,month7,month8,month9,month10,month11,month12,heji)

SELECT '' AS pid,'--' AS pname,'' AS cid,'总合计:' AS cname,'' AS ct1id,'--' AS ct1name,'' AS ct2id,'--' AS ct2name,SUM(month1) AS month1,SUM(month2) AS month2,SUM(month3) AS month3,SUM(month4) AS month4,

SUM(month5) AS month5,SUM(month6) AS month6,SUM(month7) AS month7,SUM(month8) AS month8,SUM(month9) AS month9,SUM(month10) AS month10,SUM(month11) AS month11,SUM(month12) AS month12,SUM(heji) AS heji

FROM tmp_result;

IF ireport_chart  = 'report' OR ireport_chart  = 'REPORT' THEN

SELECT pid,pName,cid,cName,ct1id,ct1Name,ct2id,ct2Name,month1,month2,month3,month4,month5,month6,month7,month8,month9,month10,month11,month12,heji FROM tmp_result;

END IF;

IF ireport_chart  = 'chart' OR ireport_chart  = 'CHART' THEN

SELECT '' AS pid,pName,'' AS cid,'' AS cName,'' AS ct1id,'' AS ct1Name,'' AS ct2id,'' AS ct2Name,SUM(month1) as month1,SUM(month2) as month2,SUM(month3) as month3,SUM(month4) as month4,

SUM(month5) as month5,SUM(month6) as month6,SUM(month7) as month7,SUM(month8) as month8,SUM(month9) as month9,SUM(month10) as month10,SUM(month11) as month11,SUM(month12) as month12,'' AS heji

FROM (SELECT pid,pName,cid,cName,ct1id,ct1Name,ct2id,ct2Name,month1,month2,month3,month4,month5,month6,month7,month8,month9,month10,month11,month12 FROM tmp_result WHERE pname <> '--') AS ir

GROUP BY pid;

END IF;

END IF;

IF qureyType  = 'week' OR qureyType  = 'WEEK' THEN

IF EXISTS(SELECT * FROM information_schema.`TABLES` T WHERE TABLE_NAME = 'tmp_result' AND TABLE_SCHEMA = ku) THEN

DROP TABLE tmp_result;

END IF;

CREATE TABLE tmp_result

(pid VARCHAR(50),pName VARCHAR(50),cid VARCHAR(50),cName VARCHAR(50),ct1id VARCHAR(50),ct1Name VARCHAR(50),ct2id VARCHAR(50),ct2Name VARCHAR(50),week1 INTEGER,week2 INTEGER,week3 INTEGER,week4 INTEGER,heji INTEGER);

lable_exit: BEGIN

SET @SqlCmd = ' INSERT INTO tmp_result (pid,pname,cid,cname,ct1id,ct1name,ct2id,ct2name)

SELECT pid,pname,cid,cname,ct1id,ct1name,ct2id,ct2name FROM

(SELECT ia.pid,a.name AS pname,ia.cid,b.name AS cname,ia.ct1id,c.name AS ct1name,ia.ct2id,d.name AS ct2name

FROM ireport ia

LEFT JOIN province a ON ia.pid=a.id

LEFT JOIN city b ON ia.cid=b.id

LEFT JOIN t_category1 c ON ia.ct1id=c.id

LEFT JOIN t_category2 d ON ia.ct2id=d.id

WHERE YEAR(ia.creatTime)=YEAR(?) And MONTH(ia.creatTime)=MONTH(?) ';

IF p_ids IS NOT NULL AND p_ids <> '' THEN

SET @SqlCmd = CONCAT(@SqlCmd , 'and ia.pid in (');

SET @SqlCmd = CONCAT(@SqlCmd, p_ids);

SET @SqlCmd = CONCAT(@SqlCmd, ')');

END IF;

IF c_ids IS NOT NULL AND c_ids <> '' THEN

SET @SqlCmd = CONCAT(@SqlCmd , 'and ia.cid in (');

SET @SqlCmd = CONCAT(@SqlCmd, c_ids);

SET @SqlCmd = CONCAT(@SqlCmd, ')');

END IF;

IF ct1_ids IS NOT NULL AND ct1_ids <> '' THEN

SET @SqlCmd = CONCAT(@SqlCmd , 'and ia.ct1id in (');

SET @SqlCmd = CONCAT(@SqlCmd, ct1_ids);

SET @SqlCmd = CONCAT(@SqlCmd, ')');

END IF;

IF ct2_ids IS NOT NULL AND ct2_ids <> '' THEN

SET @SqlCmd = CONCAT(@SqlCmd , 'and ia.ct2id in (');

SET @SqlCmd = CONCAT(@SqlCmd, ct2_ids);

SET @SqlCmd = CONCAT(@SqlCmd, ')');

END IF;

SET @SqlCmd = CONCAT(@SqlCmd , ') AS ir GROUP BY pid,pname,cid,cname,ct1id,ct1name,ct2id,ct2name;');

PREPARE stmt1 FROM @SqlCmd;

SET @a = daytime;

EXECUTE stmt1 USING @a,@a;

DEALLOCATE PREPARE stmt1;

LEAVE lable_exit;

END lable_exit;

WHILE i <= 4 DO

lable_exit: BEGIN

SET @SqlCmd = 'UPDATE tmp_result AS a,

(

SELECT pid,cid,ct1id,ct2id,SUM(crawlerNumber) AS crawlerNumber FROM

(SELECT pid,cid,ct1id,ct2id,crawlerNumber FROM ireport WHERE WEEK=? AND MONTH(creatTime)=MONTH(?)) AS ir

GROUP BY pid,cid,ct1id,ct2id

) AS b

SET a.week';

SET @SqlCmd = CONCAT(@SqlCmd , i);

SET @SqlCmd = CONCAT(@SqlCmd , '=b.crawlerNumber ');

SET @SqlCmd = CONCAT(@SqlCmd , 'WHERE a.pid=b.pid AND a.cid=b.cid AND a.ct1id=b.ct1id AND a.ct2id=b.ct2id; ');

PREPARE stmt1 FROM @SqlCmd;

SET @a = i;

SET @b = daytime;

EXECUTE stmt1 USING @a,@b;

DEALLOCATE PREPARE stmt1;

LEAVE lable_exit;

END lable_exit;

lable_exit: BEGIN

SET @SqlCmd = 'UPDATE tmp_result SET week';

SET @SqlCmd = CONCAT(@SqlCmd , i);

SET @SqlCmd = CONCAT(@SqlCmd , ' = 0 WHERE week');

SET @SqlCmd = CONCAT(@SqlCmd , i);

SET @SqlCmd = CONCAT(@SqlCmd , ' IS NULL');

PREPARE stmt1 FROM @SqlCmd;

EXECUTE stmt1;

DEALLOCATE PREPARE stmt1;

LEAVE lable_exit;

END lable_exit;

SET i = i + 1;

END WHILE;

UPDATE tmp_result SET heji=week1+week2+week3+week4;

INSERT INTO tmp_result (pid,pname,cid,cname,ct1id,ct1name,ct2id,ct2name,week1,week2,week3,week4,heji)

SELECT '' AS pid,'--' AS pname,'' AS cid,'总合计:' AS cname,'' AS ct1id,'--' AS ct1name,'' AS ct2id,'--' AS ct2name, SUM(week1) AS week1,SUM(week2) AS week2,SUM(week3) AS week3,SUM(week4) AS week4,SUM(heji) AS heji

FROM tmp_result;

IF ireport_chart  = 'report' OR ireport_chart  = 'REPORT' THEN

SELECT pid,pName,cid,cName,ct1id,ct1Name,ct2id,ct2Name,week1,week2,week3,week4,heji FROM tmp_result;

END IF;

IF ireport_chart  = 'chart' OR ireport_chart  = 'CHART' THEN

SELECT '' as pid,pName,'' as cid,'' as cName,'' as ct1id,'' as ct1Name,'' as ct2id,'' as ct2Name,SUM(week1) AS week1,SUM(week2) AS week2,SUM(week3) AS week3,SUM(week4) AS week4,'' as heji

FROM (SELECT pid,cid,pname,cname,week1,week2,week3,week4 FROM tmp_result WHERE pname <> '--') AS ir

GROUP BY pid;

END IF;

END IF;

END $$

DELIMITER ;

/

创建一个EVENT.

SQL code

DELIMITER //

DROP EVENT IF EXISTS delOldData//

CREATE EVENT `delOldData`

ON SCHEDULE EVERY 1 DAY

STARTS '2010-03-01 00:00:01'

ENDS '2020-12-31 00:00:01'

ON COMPLETION NOT PRESERVE

ENABLE

DO

BEGIN

DELETE FROM your_table WHERE column_date<=DATE_ADD(CURDATE(),INTERVAL -7 DAY);

END;

//

DELIMITER ;

每晚00：00：01删除7天前数据。

///

每个月的一号凌晨1 点执行

CREATE EVENT EVENT2

ON SCHEDULE EVERY 1 MONTH STARTS DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH),INTERVAL 1 HOUR)

ON COMPLETION PRESERVE ENABLE

DO

BEGIN

CALL STAT();

END

每个季度一号的凌晨2点执行

CREATE EVENT TOTAL_SEASON_EVENT

ON SCHEDULE EVERY 1 QUARTER STARTS DATE_ADD(DATE_ADD(DATE( CONCAT(YEAR(CURDATE()),'-',ELT(QUARTER(CURDATE()),1,4,7,10),'-',1)),INTERVAL 1 QUARTER),INTERVAL 2 HOUR)

ON COMPLETION PRESERVE ENABLE

DO

BEGIN

CALL SEASON_STAT();

END

每年1月1号凌晨四点执行

CREATE EVENT TOTAL_YEAR_EVENT

ON SCHEDULE EVERY 1 YEAR STARTS DATE_ADD(DATE(CONCAT(YEAR(CURDATE()) + 1,'-',1,'-',1)),INTERVAL 4 HOUR)

ON COMPLETION PRESERVE ENABLE

DO

BEGIN

CALL YEAR_STAT();

END

二佳啊i
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL_5.1_zh.rar_MYSQL_MySQL_5.1_zh_mysql 中文
09-21
MySQL_5.1_zh.rar 是一个包含 MySQL 5.1 版本中文文档的压缩文件，主要提供了关于 MySQL 数据库管理系统在5.1版本中的详细说明。MySQL 是一款广泛使用的开源关系型数据库系统，以其高效、稳定和易用性闻名。在 MySQL...
MySql-存储过程和事件，每月定时创建一张表
夏寻的博客
06-16 1192
存储过程基本命令、Mysql如何每月自动建表？、水平分表维护思路
mysql中创建borrow_Mysql数据库（八）存储过程与存储函数
weixin_29325515的博客
02-07 1042
一、创建存储过程与存储函数1.创建存储过程(实现统计tb_borrow1数据表中指定图书编号的图书的借阅次数)mysql> delimiter //mysql> CREATE PROCEDURE proc_count(IN id INT,OUT borrowcount INT)-> READS SQL DATA-> BEGIN-> SELECT count(*) IN...
mysql 创建事件
最新发布
qq_50761817的博客
04-20 143
2、查看是否开启事件。
CTGU实验5_1-创建还书过程中的触发器
cty的博客
05-05 2734
工具推荐 educoder自动输入工具 任务描述 创建一个触发器tri_returnbook，当一本书被还回时，从LOAN表中删除相应的借阅记录，将该学生借阅这本书记录添加到LoadHist表中；并检查是否有用户在等待预约这本书：如有则将这本书的借阅状况修改为 已经预约，并按照预约的日期先后，将最先预约的预约状态改为T；如果没有人预约，则应该将此书的借阅状况修改为“可以借阅且尚未借出”（修改状态字段值） /* 1. 创建一个触发器tri_returnbook，当一本书被还回时，从LOAN表中删除相应的借阅
mysql 使用 定时器 执行任务
weixin_42041819的博客
06-29 445
mysql 使用定时器执行任务 – mysql定时器是系统给提供了event – 创建存储过程，这里的存储过程主要提供给mysql的定时器event来调用去执行 create procedure mypro() BEGIN update table set ncoalState=1 where ncoalId=‘SX30002’; //设置时间为当前时间戳 毫秒为单位 INSERT INTO table (sendTime) VALUES (unix_timestamp(now())*1000); end;
MySQL定时任务（EVENT|事件）如何配置，必会技能！
热门推荐
陈哈哈的菜园子
11-20 2万+
MySQL的定时任务你用过没？是真的好用，日后跟同事吹逼的利器。来不及了，快上车！！
MySQL_5.1_zh.rar_MySQL_5.1_zh
09-20
这个名为 "MySQL_5.1_zh.rar" 的压缩包包含了一个名为 "MySQL_5.1_zh.chm" 的CHM格式文件，这是一种微软的HTML帮助文件，用于存储大量的离线文档。此外，还有一个 "www.pudn.com.txt" 的文本文件，可能是发布者提供...
MySQL_5.1_zh中文手册
02-14
MySQL_5.1_zh中文手册 本手册编译于2006-7-29，目录及索引由官方HTML文档转换并加以修订，如有链接错误请发送邮件至： hemono@gmail.com 。获取最新CHM及PDF版本，请访问：hemon.ecjtu.net 。 张伟，华东交通大学。
MySQL_5.1_zh.chm
03-30
本资源“MySQL_5.1_zh.chm”是一个中文版的手册，旨在帮助用户理解和掌握 MySQL 5.1 的各种特性和操作。 MySQL 是一个开源的关系型数据库管理系统，其核心特性包括ACID（原子性、一致性、隔离性、持久性）事务支持...
MySQL_5.1_zh.zip
07-04
MySQL_5.1_zh.zip 是一个针对MySQL数据库系统5.1版本的中文离线文档，它包含了关于MySQL安装、操作命令及实际应用的详细指南。这个文档集合以CHM（Microsoft Compiled HTML Help）格式呈现，便于用户在没有网络连接...
Mysql创建事件执行任务
tanqingfu1的博客
04-14 4861
1、CREATE EVENT创建事件语法 在 MySQL 中，可以通过CREATE EVENT语句来创建事件，其语法格式如下： CREATE EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'comment'] DO event_body; 2、查...
MySQL数据库定时任务——事件
Java+GO+JS全栈工程师-鹤冲天的博客：编程辅导~商务合作~技术交流
11-06 5591
使用 MySQL 事件可以轻松地执行周期性的任务，从而提高数据库效率和性能。掌握如何使用事件是管理和优化 MySQL 数据库的重要知识点，可以更好地理解MySQL事件的特点和使用方式，从而更好地使用MySQL。希望本文对你有所帮助。
Java_Event事件发布与监听
2Mins you can do anything
10-21 2845
使用场景 要接受消息进行存库操作，但是消息的来源是不固定的，有多个来源，触发的事件也是不固定的，最简单的一种方式是通过写接口然后二次调接口的方式来实现，但是这样又相当于多了一次操作，性能会降低，所以通过事件监听的方式来进行。 Event组成部分 完成一个完整的Event操作需要有三个部分：事件、事件监听器、事件发布器 示例 1、首先如果我们需要先定义一个事件，这里我们定义一个MessageEvent事件。需要继承Spring提供的ApplicationEvent类，这个类继承了JDK中的事件基类EventO
mysql 创建事件，样例
01-12 478
mysql 创建事件，样例
mysql定时任务(event事件)实现详解
weixin_43110668的博客
10-13 1505
一个事件可以是活动（打开）的或停止（关闭）的，活动意味着事件调度器检查事件动作是否必须调用，停止意味着事件的声明存储在目录中，但调度器不会检查它是否应该调用。事件取代了原先只能由操作系统的计划任务来执行的工作，而且MySQL的事件调度器可以精确到每秒钟执行一个任务，而操作系统的计划任务（如：Linux下的CRON或Windows下的任务计划）只能精确到每分钟执行一次。相当注释，最大长度64个字节。事件执行完即释放，如立即执行事件，执行完后，事件便自动删除，多次调用事件或等待执行事件可以查看到。
创建事件（event）
kankankankan2222的专栏
12-19 1650
事件（event）： 让我通过一个例子来模拟事件的整个过程： 创建一个button类，它里面有一个click 事件。 创建一个Form类，他里面有一个我们上面定义的button类。 要求：当我们用户单击button类的时候From类要对他进行处理，输出一条信息“我知道你被单击了” 请看下图： 首先我们会单击button，然后button会通知Form，然后From就作出相应。这
mysql数据库创建事件定时运行动态sql
LB_bei的博客
03-22 255
该事件将在每天的指定时间（2024-03-22 00:00:10）开始执行，并且每隔1分钟执行一次。事件的主要功能是执行一段动态生成的SQL语句，该SQL语句将数据从一个表（以当前月份和日期命名的表）插入到另一个表中（以当前月份命名的表）。
mysql5.1 文档
07-29
MySQL 5.1 是一种关系型数据库管理系统，通过提供一个功能强大的数据库服务，可以存储和管理大量的数据。MySQL的主要特点之一是它的开放源代码和免费使用，这使得它成为许多开发人员和组织的首选数据库选择。 MySQL...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值