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 votes74 views1 answer
Postgres upsert
SQL
0 vote121 views1 answer
SQL Server Enterprise
SQL
2 votes112 views2 answers
Mysql all columns
SQL
0 vote172 views1 answer
Show mysql account privilleges
SQL
1 vote133 views1 answer
Oracle drop job if exists
SQL
16 votes115 views2 answers
Add column to all tables after first column mysql
SQL
0 vote118 views1 answer
How to update date value in sql
SQL
0 vote124 views1 answer
Learnxinyminutes sql
SQL
1 vote119 views1 answer
Psql human readable
SQL
0 vote141 views1 answer
Sql developer sql worksheet not showing
SQL