Create Trigger and Drop Trigger structure » Create Dynamic

MySQL Generator

Create/Drop Trigger Structure

Trigger Name

Table Name

Trigger Time

Trigger Event

Trigger Body (SQL statement)

Create Trigger:Query Output:

CopiedCopy Code

DELIMITER $$
CREATE TRIGGER <trigger_name> <trigger_time> <trigger_event> ON <table_name>
FOR EACH ROW
BEGIN
<trigger_body>
END$$
DELIMITER ;

Drop Trigger:Query Output:

CopiedCopy Code

DROP TRIGGER <trigger_name>;

Create | Rename | Drop Databases Create Table Alter | Copy | Drop Table Table Select | Delete Table Data Insert | Update Table Data Alter Table - Add Fields Alter Table - Modify Fields Alter Table - Change Fields Alter Table - Drop Fields Alter Table - Add | Drop Foreign Key Alter Table - Add | Drop Primary Key Alter Table - Add | Drop Unique Key Create | Drop Procedure Create | Drop Functions Create | Drop View Create | Drop Trigger