MySQL事件

创建事件

CREATE DEFINER=`wlc1000`@`%` EVENT `autoInsert`
	ON SCHEDULE
		EVERY 1 SECOND STARTS '2020-12-02 09:27:35'
	ON COMPLETION PRESERVE
	ENABLE
	COMMENT ''
	DO BEGIN
insert into test (No,Name,createdate) values (FLOOR(RAND() * 10000),UNIX_TIMESTAMP(),NOW());
END

查看事件
show processlist;

事件状态
show variables like 'event_scheduler';

设置可以执行事件
set global event_scheduler=on;