Events not working db

Events are run by the scheduler, which is not started by default.
mysql> SHOW PROCESSLIST;
The event_scheduler is running, but it doesn't appear in the list. For me it's better to use
mysql> select @@event_scheduler;
OR, you can also verify using the following command:
mysql> SELECT @@global.event_scheduler;
The result should be ON, otherwise set it off (will get 0 for the command), as stated in the next section
If you don't have any such entry (as above), you may start the event scheduler using the following command:
mysql> SET GLOBAL event_scheduler = ON;

Similar codes

13 votes325 views2 answers
Sql count distinct group by
SQL
0 vote347 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote313 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote401 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
104 votes533 views2 answers
Like in mysql
SQL
0 vote307 views1 answer
Sql query with date
SQL
0 vote348 views1 answer
Create table like sql
SQL
9 votes319 views4 answers
Last mysql
SQL
0 vote348 views1 answer
Sql filter rows with condition
SQL
0 vote328 views1 answer
Postgresql certain first 4 characters in string
SQL