Friday 10 September 2010

How to create a MySQL Trigger

How to create a MySQL Trigger

This is the sintax:
CREATE [DEFINER = { user | CURRENT_USER }]
TRIGGER
trigger_name {AFTER | BEFORE} {INSERT | UPDATE | DELETE}
ON
tbl_name FOR EACH ROW {your_body}

An example:

CREATE TRIGGER sdata_insert BEFORE INSERT ON `sometable`
FOR EACH ROW
BEGIN
SET NEW.guid = UUID();
END
;

0 comments: