Wednesday, September 23, 2009

MYSQL Triggers examples.

Trigger syntax
CREATE TRIGGER "trigger_name" "triggger_time"
"trigger_event" ON "table_name_onwhichtriggershouldfire"
FOR EACH ROW
BEGIN
""trigger_statements"
END;

Examples :
CREATE TRIGGER insert_test AFTER INSERT ON component
FOR EACH ROW
BEGIN
INSERT INTO TAG (name) VALUES (new.Name);
END;
Dropping Trigger
DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name
example :
drop trigger [if exists] osmp.testTrigger
Show all the triggers
SHOW TRIGGERS
Show particular Trigger
show create trigger "trigger_name"

No comments: