<\/span><\/h3>\n\n\n\nCREATE [DEFINER = { user | CURRENT_USER }] EVENT\n[IF NOT EXISTS] event_name\nON SCHEDULE schedule\n[ON COMPLETION [NOT] PRESERVE]\n[ENABLE | DISABLE]\n[global|local]\n[COMMENT 'comment']\nDO event_body;\nschedule:\nAT timestamp [+ INTERVAL interval] ... | EVERY interval\n[STARTS timestamp [+ INTERVAL interval] ...]\n[ENDS timestamp [+ INTERVAL interval] ...]\ninterval:\nquantity { YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |WEEK |\nSECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE | DAY_SECOND | HOUR_MINUTE\n| HOUR_SECOND | MINUTE_SECOND }\n<\/code><\/pre>\n\n\n\n<\/span>\u4fee\u6539<\/span><\/h3>\n\n\n\n<\/span>\u4fee\u6539\u5b9a\u65f6\u4efb\u52a1\u7684\u8c03\u5ea6\u53c2\u6570<\/span><\/h4>\n\n\n\ngbase> alter event import_audit_log ON SCHEDULE every 10 minute;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.02)\n<\/code><\/pre>\n\n\n\n<\/span>\u4fee\u6539\u5b9a\u65f6\u4efb\u52a1\u540d\u5b57<\/span><\/h4>\n\n\n\ngbase> alter event import_audit_log rename to import_audit_log2;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>\u5220\u9664<\/span><\/h3>\n\n\n\ndrop event\uff0c \u5c31\u4e0d\u505a\u4ecb\u7ecd\u4e86\u3002<\/p>\n\n\n\n
gbase> drop event drop_temp_table;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.08)\n<\/code><\/pre>\n\n\n\n<\/span>\u521b\u5efa\u4efb\u52a1\u8868\uff0c\u7528\u4e8e\u8bb0\u5f55\u6d4b\u8bd5\u7ed3\u679c<\/span><\/h2>\n\n\n\ngbase> create table tevent(d datetime);\nQuery OK, 0 rows affected (Elapsed: 00:00:00.61)<\/code><\/pre>\n\n\n\n<\/span>\u521b\u5efa\u6700\u7b80\u5355\u7684\u4e00\u6b21\u6027event<\/span><\/h2>\n\n\n\n\u8be5event\u53ea\u8fd0\u884c\u4e00\u6b21\uff0c\u4e14\u9a6c\u4e0a\u8fd0\u884c\u3002 <\/p>\n\n\n\n
gbase> create event test_event1 on schedule at current_timestamp do insert into tevent values(now());\nQuery OK, 0 rows affected (Elapsed: 00:00:00.10)<\/code><\/pre>\n\n\n\n<\/span>\u67e5\u770b\u8fd0\u884c\u7ed3\u679c<\/span><\/h2>\n\n\n\ngbase> select * from tevent;\n+---------------------+\n| d |\n+---------------------+\n| 2020-08-15 19:55:53 |\n+---------------------+\n1 row in set (Elapsed: 00:00:00.02)<\/code><\/pre>\n\n\n\n<\/span>\u7acb\u5373\u8fd0\u884c\u7684event\u53ef\u80fd\u4e0d\u4f1a\u8fd0\u884c<\/span><\/h2>\n\n\n\n\u56e0\u4e3a\u521b\u5efa\u65f6\u95f4\u548c\u8c03\u5ea6\u65f6\u95f4\u7684\u504f\u5dee\uff0c\u5982\u4e0a\u7684event,\u6709\u8f83\u5927\u51e0\u7387\u51fa\u73b0\u521a\u521b\u5efa\u5b8c\uff0c\u8fd8\u6ca1\u8fd0\u884c\uff0c\u5c31\u53d1\u73b0\u8fc7\u671f\u4e86\uff0c\u76f4\u63a5\u5c31\u88ab\u5220\u9664\u4e86\uff0c\u5bfc\u81f4event\u6839\u672c\u6ca1\u6709\u88ab\u6267\u884c\u3002\u8bf7\u5728\u5f00\u59cb\u8fd0\u884c\u65f6\u95f4\u505a\u7cbe\u786e\u6307\u5b9a\uff0c\u6216\u8005\u5ef6\u540e\u4e00\u6bb5\u65f6\u95f4\uff0c\u8bf7\u53c2\u8003\u540e\u9762\u7684\u4f8b\u5b50\u3002<\/p>\n\n\n\n
gbase> create event test_event2 on schedule at current_timestamp do insert into tevent values(now());\nQuery OK, 0 rows affected, 1 warning (Elapsed: 00:00:00.10)<\/span>\n\ngbase> show warnings;\n+-------+------+------------------------------------------------------------------------------------------------------------------------------------------------+\n| Level | Code | Message |\n+-------+------+------------------------------------------------------------------------------------------------------------------------------------------------+\n| Note | 1588 | 10.0.2.202:5258 - Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation. |\n+-------+------+------------------------------------------------------------------------------------------------------------------------------------------------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u521b\u5efa\u5ef6\u8fdf\u6267\u884c\u7684event<\/span><\/h2>\n\n\n\n\u901a\u8fc7\u5728current_timestamp\u589e\u52a0\u4e00\u90e8\u5206\u65f6\u95f4\uff0c\u6765\u5ef6\u8fdf\u6267\u884c\u3002\u5982\u6709\u56fa\u5b9a\u65f6\u95f4\uff0c\u8bf7\u53c2\u8003\u540e\u9762\u7684\u5b9a\u65f6\u6267\u884c\u3002<\/p>\n\n\n\n
gbase> create event test_event2 on schedule at current_timestamp+interval 10 second do insert into tevent values(now());\nQuery OK, 0 rows affected (Elapsed: 00:00:00.46)\n\ngbase> select * from tevent;\n+---------------------+\n| d |\n+---------------------+\n| 2021-10-23 15:35:54 |\n| 2021-10-23 15:47:47 |\n| 2021-10-23 15:48:50 |\n+---------------------+\n3 rows in set (Elapsed: 00:00:00.03)\n\ngbase> select * from tevent;\n+---------------------+\n| d |\n+---------------------+\n| 2021-10-23 15:35:54 |\n| 2021-10-23 15:47:47 |\n| 2021-10-23 15:48:50 |\n| 2021-10-23 15:53:15 |\n+---------------------+\n4 rows in set (Elapsed: 00:00:00.03)\n<\/code><\/pre>\n\n\n\n<\/span>\u521b\u5efa\u5b9a\u70b9\u8fd0\u884c\u7684event<\/span><\/h2>\n\n\n\n\u5982\u4e0bevent,\u4f7f\u7528\u4e86\u7edd\u5bf9\u65f6\u95f4'2021-10-23 15:56:13'\u6765\u6267\u884cevent<\/p>\n\n\n\n
gbase> create event test_event2 on schedule at '2021-10-23 15:56:13' do insert into tevent values(now());\nQuery OK, 0 rows affected (Elapsed: 00:00:00.10)\n\ngbase> select * from tevent;\n+---------------------+\n| d |\n+---------------------+\n| 2021-10-23 15:35:54 |\n| 2021-10-23 15:47:47 |\n| 2021-10-23 15:48:50 |\n| 2021-10-23 15:53:15 |\n+---------------------+\n4 rows in set (Elapsed: 00:00:00.03)\n\ngbase> select now(),t.* from tevent t;\n+---------------------+---------------------+\n| now() | d |\n+---------------------+---------------------+\n| 2021-10-23 15:56:25 | 2021-10-23 15:35:54 |\n| 2021-10-23 15:56:25 | 2021-10-23 15:47:47 |\n| 2021-10-23 15:56:25 | 2021-10-23 15:48:50 |\n| 2021-10-23 15:56:25 | 2021-10-23 15:53:15 |\n| 2021-10-23 15:56:25 | 2021-10-23 15:56:13 |\n+---------------------+---------------------+\n5 rows in set (Elapsed: 00:00:00.03)\n<\/code><\/pre>\n\n\n\n<\/span>\u67e5\u770bevent\u662f\u5426\u8fd8\u5b58\u5728<\/span><\/h2>\n\n\n\n\u6ce8\u610f\uff1a\u5982\u679cevent\u8fd0\u884c\u4e2d\u95f4\u62a5\u9519\uff0c\u5219event\u4e0d\u4f1a\u88ab\u81ea\u52a8\u5220\u9664\u3002<\/span><\/p>\n\n\n\ngbase> show events;\nEmpty set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n