MySQL timed to insert one piece of data per second

1. Create a table

2. Create a stored procedure

CREATE PROCEDURE User ()
INSERT into User (name,sex) VALUES (' 1111 ', ' 1 ');

3. Create timer

CREATE EVENT IF not EXISTS eventjob
On SCHEDULE every 1 SECOND
On completion PRESERVE
Do call user ();

4.

Turn on event test_event
Alter event eventjob on completion preserve enable;
Shutdown Event Test_event
Alter event eventjob on C

5.

SET GLOBAL event_scheduler = 1; --Start Timer
SET GLOBAL event_scheduler = 0; --Stop Timer

MySQL timed to insert one piece of data per second