create event if not exists event_insertdt on schedule every 1 minute
on completion preserve
do insert into test_data (receivetime, distance)values(current_timestamp, '0.3');
创建每天凌晨1点执行的事件
create event if not exists event_insertdt
on schedule every 1 day starts date_add(date_add(curdate(), interval 1 day), interval 1 hour)
on completion preserve enable
do insert into test_data (receivetime, distance)values(current_timestamp, '0.3');