Triggers automatically execute SQL code when specific events occur. Automate auditing, validation, and data maintenance.

Create Trigger (MySQL)

CREATE TRIGGER before_order_insert

BEFORE INSERT ON orders

FOR EACH ROW

SET NEW.created_at = NOW();

Trigger Types

BEFORE INSERT

AFTER INSERT

BEFORE UPDATE

AFTER UPDATE

BEFORE DELETE

AFTER DELETE

Audit Trail Trigger

CREATE TRIGGER audit_customer_update

AFTER UPDATE ON customers

FOR EACH ROW

INSERT INTO audit_log (table_name, record_id, old_value, new_value, changed_at)

VALUES ('customers', OLD.id, OLD.email, NEW.email, NOW());

Validation Trigger

CREATE TRIGGER check_price

BEFORE INSERT ON products

FOR EACH ROW

BEGIN

IF NEW.price < 0 THEN

SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Price cannot be negative';

END IF;

END;

Drop Trigger

DROP TRIGGER IF EXISTS before_order_insert;

Generate Triggers

AI2sql creates trigger logic from your requirements.