· 8 years ago · May 30, 2018, 08:26 PM
1DROP TRIGGER IF EXISTS trigger_name;
2DELIMITER //
3CREATE TRIGGER trigger_name BEFORE UPDATE ON table
4FOR EACH ROW BEGIN
5 -- Trigger logic goes here
6END //
7DELIMITER;
8
9-- More trigger drop/create statements follow
10
11DELIMITER ;
12
13DELIMITER;
14
15DELIMITER ;
16# not:
17DELIMITER;