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

0 vote139 views1 answer
Default column value in sql same as another column laravel
SQL
8 votes122 views2 answers
Replace string value in sql
SQL
0 vote121 views1 answer
Mysql remove tabs from string
SQL
5 votes120 views1 answer
Oracle scan source ddl
SQL
0 vote129 views1 answer
Delete record by id sql
SQL
1 vote93 views5 answers
Spring boot sql logging
SQL
1 vote118 views2 answers
Mysql allow remote connections
SQL
2 votes133 views1 answer
Mariadb select multiple rows into one column
SQL
1 vote122 views1 answer
Postgresql substring last
SQL
1 vote133 views1 answer
Join to find results not in another table
SQL