mysqldatabasecronjob-schedulingmysql-event

Show all MySQL events that are running on my database?


I have a MySQL database. I am running two MySQL EVENTs. I need to get rid of one. I don't remember it's name. What do I do?


Solution

  • its simple SHOW EVENTS lists all of the events in the current schema

    To see events for a specific schema, use the FROM clause. For example, to see events for the test schema, use the following statement:

    SHOW EVENTS FROM test;