- 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 delete an existing MySQL event permanently?
We need to use the DROP statement to delete an existing MySQL event permanently. To illustrate it we are deleting the event named testing_event as follows −
Example
mysql> DROP EVENT testing_event; Query OK, 0 rows affected (0.00 sec)
- Related Articles
- How can we modify an existing MySQL event?
- How can we RENAME an existing MySQL event?
- How can we delete an existing MySQL table by using PHP script?
- How can I move an existing MySQL event to another database?
- How can we start MySQL event scheduler?
- How can we get a list of columns in an existing MySQL table?
- How can we add columns with default values to an existing MySQL table?
- How Can we permanently define user-defined variable for a client in MySQL?
- How can we create a table from an existing MySQL table in the database?
- How can we add multiple columns, with single command, to an existing MySQL table?
- How can we insert data into an existing MySQL table by using PHP script?
- How can we apply UNIQUE constraint to the field of an existing MySQL table?
- How can we set PRIMARY KEY on multiple columns of an existing MySQL table?
- How to permanently delete a YouTube video?
- How can we remove NOT NULL constraint from a column of an existing MySQL table?
Advertisements