GBASE 8A 之EVENT

创建测试表：
gbase> DROP TABLE IF EXISTS events_list;
gbase> CREATE TABLE events_list(event_name VARCHAR(20) NOT NULL, event
_started tIMESTAMP NOT NULL);
创建事件 1 （立即启动事件）：
CREATE EVENT event_now
ON SCHEDULE
AT NOW()
DO insert into events_list values('event_now', now());
查看事件执行结果：
gbase> select * from events_list;
+------------+---------------------+
| event_name | event_started |
+------------+---------------------+
| event_now | 2025-06-26 14:06:40 |
+------------+---------------------+
创建事件 2 （每分钟启动事件）：
CREATE EVENT test.event_minute
ON SCHEDULE
EVERY 1 MINUTE
DO insert into events_list values('event_now', now());
查看事件执行结果：
gbase> SELECT * FROM events_list; 
+-------------+---------------------+
| event_name | event_started |
+-------------+---------------------+
| event_now | 2025-06-26 14:10:35 |
| event_now | 2025-06-26 14:11:35 |
| event_now | 2025-06-26 14:12:35 |
+-------------+---------------------+