在过程中创建事件 - SQL

发布于 2024-12-19 13:49:40 字数 428 浏览 0 评论 0原文

我需要在过程中创建一个事件，我在某处读到这是可能的，但我不知道语法。我正在尝试：

CREATE PROCEDURE DUMMY_PROCEDURE() 
BEGIN 
CREATE event e on schedule every 1 second DO 
INSERT INTO test.t values (current_timestamp); 
END;

但它抛出：

关于如何做到这一点的任何想法？感谢您的阅读。

'#1576 - 当主体存在时禁止 EVENT DDL 语句的递归

Edit1:
我想在事件过程中创建事件的原因是因为它充当到期日期，因此执行该函数时还会创建具有非常特定参数的事件，因此当到期日期到来时，银行会自动执行特定操作。理解？

原文

I need to create an event inside a procedure, I read somewhere that it's possible but I don't know the syntax. I'm trying:

CREATE PROCEDURE DUMMY_PROCEDURE() 
BEGIN 
CREATE event e on schedule every 1 second DO 
INSERT INTO test.t values (current_timestamp); 
END;

But it throws:

Any ideas on how to do this?, thanks for reading.

'#1576 - Recursion of EVENT DDL statements is forbidden when body is present

Edit1:
The reason I want to create an event within an event procedure is because it acts as an expiration date, so the function is executed an event with very specific parameters is also created, so when the expiration date arrives, automatically bank makes a particular action. Understand?

分享到QQ

分享到微博