mysql events
mysql> show events \G;
*************************** 1. row ***************************
Db: zhyu
Name: e_zhyu_01
Definer: root@localhost
Time zone: SYSTEM
Type: RECURRING
Execute at: NULL
Interval value: 1
Interval field: MINUTE
Starts: 2023-03-21 17:30:00
Ends: NULL
Status: ENABLED
Originator: 1
character_set_client: utf8mb4
collation_connection: utf8mb4_0900_ai_ci
Database Collation: utf8mb4_0900_ai_ci
1 row in set (0.00 sec)
create event e_zhyu_01
on schedule
every '1' minute starts '2023-03-21 17:30:00'
do insert into zhyu.t values(now());
页:
[1]