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

5 votes364 views1 answer
Oracle list functions
SQL
0 vote348 views1 answer
Sql server 2012 create or alter procedure
SQL
23 votes367 views2 answers
Query to delete a database in mysql
SQL
1 vote362 views1 answer
Sql server datetime vs datetime2
SQL
0 vote358 views1 answer
Custom row number
SQL
0 vote367 views1 answer
Str_to_date sql server
SQL
0 vote447 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote343 views6 answers
Unique key in sql
SQL
0 vote377 views1 answer
Sql show table name in result
SQL
0 vote373 views1 answer
Sort by
SQL