How to delete triggers from mysql database?

青灯夜游
Release: 2020-10-13 15:59:42
Original
10421 people have browsed it

In mysql, you can use the "DROP TRIGGER" statement to delete a defined trigger. The syntax format is "DROP TRIGGER [IF EXISTS] [database name] trigger name"; when deleting a table, it also Triggers on the table are automatically deleted.

How to delete triggers from mysql database?

(Recommended tutorial:mysql video tutorial)

Delete trigger

Use the DROP TRIGGER statement to delete triggers that have been defined in MySQL.

The syntax format is as follows:

DROP TRIGGER [ IF EXISTS ] [数据库名] <触发器名>
Copy after login

The syntax description is as follows:

1) Trigger name

The name of the trigger to delete.

2) Database name

optional. Specifies the name of the database where the trigger resides. If not specified, it is the current default database.

3) Permissions

SUPER permission is required to execute the DROP TRIGGER statement.

4) IF EXISTS

Optional. Avoid deleting triggers without triggers.

Note: When a table is deleted, the triggers on the table will also be automatically deleted. In addition, triggers cannot be updated or overwritten. In order to modify a trigger, you must first delete it and then recreate it.

[Example]Delete the double_salary trigger. The input SQL statement and execution process are as follows.

mysql> DROP TRIGGER double_salary; Query OK, 0 rows affected (0.03 sec)
Copy after login

After deleting the double_salary trigger, when inserting records into the data table tb_emp6 again, the data in the data table tb_emp7 will no longer change, as shown below.

mysql> INSERT INTO tb_emp6 -> VALUES (3,'C',1,200); Query OK, 1 row affected (0.09 sec) mysql> SELECT * FROM tb_emp6; +----+------+--------+--------+ | id | name | deptId | salary | +----+------+--------+--------+ | 1 | A | 1 | 1000 | | 2 | B | 1 | 500 | | 3 | C | 1 | 200 | +----+------+--------+--------+ 3 rows in set (0.00 sec) mysql> SELECT * FROM tb_emp7; +----+------+--------+--------+ | id | name | deptId | salary | +----+------+--------+--------+ | 1 | A | 1 | 2000 | | 2 | B | 1 | 1000 | +----+------+--------+--------+ 2 rows in set (0.00 sec)
Copy after login

The above is the detailed content of How to delete triggers from mysql database?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!