Codiga Code Snippet: create trigger

DROP TRIGGER IF EXISTS `trigger_name`;
CREATE TRIGGER `${1}` AFTER INSERT ON `table_name` FOR EACH ROW
BEGIN
    constants
END;

create trigger

lucycodes42

SQL public snippets

This code creates a trigger named "trigger_name" that will fire after an INSERT or UPDATE statement is executed against table_name. The trigger will be fired after the new values for columns &[USER_INPUT:2:AFTER] and &[USER_INPUT:3:INSERT] are populated from the values of column &[USER_INPUT:4:table_name]. The trigger will also have a BEFORE row clause that will fire before the actual INSERT or UPDATE statement is executed.

Shortcut: s_trig

0 Comments

Add Comment