
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
How can we ENABLE AND DISABLE a particular MySQL event?
With the help of ALTER EVENT statement along with the ENABLE and DISABLE keyword, we can ENABLE and DISABLE the event. To illustrate it we are having the following example −
Example
mysql> ALTER EVENT hello DISABLE; Query OK, 0 rows affected (0.00 sec)
The above query will DISABLE the event named ‘Hello’ and the query below will enable it.
mysql> ALTER EVENT hello ENABLE; Query OK, 0 rows affected (0.00 sec)
- Related Articles
- How to disable a particular jQuery event on a page?
- How can we start MySQL event scheduler?
- How can we modify an existing MySQL event?
- How can we RENAME an existing MySQL event?
- How can I disable/enable GPS programmatically in android?
- How can we delete an existing MySQL event permanently?
- How can we fetch all the records from a particular MySQL table?
- How can we create a MySQL one-time event that executes immediately?
- How can we fetch a particular row as output from a MySQL table?
- How to Disable / Enable a Button in TKinter?
- Enable and disable interrupts in Arduino
- How can we see the source code of a particular MySQL stored procedure?
- How can we see the source code of a particular MySQL stored function?
- How we can find all the triggers associated with a particular MySQL table?
- How can we check the default character sets of a particular MySQL database?

Advertisements