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

1 vote207 views1 answer
Blob datatype in mysql
SQL
9 votes201 views3 answers
Sql delete where in
SQL
5 votes153 views1 answer
Postgres upsert
SQL
20 votes213 views5 answers
Reset auto increment mysql
SQL
9 votes197 views4 answers
How to alter table column name in mysql
SQL
0 vote189 views1 answer
Vbscript create ADODB.Connection
SQL
15 votes199 views2 answers
Select where duplicate mysql
SQL
3 votes206 views1 answer
Select count from table mysql
SQL
0 vote244 views1 answer
Composit key in sql
SQL
1 vote190 views1 answer
How to update date add hours in postgresql
SQL