Examples and Notes by Week

↑ Up to Parent directory
View Create_dorepeat_proc.sql code.	Open/Save Create_dorepeat_proc.sql.
View Create_hello_func.sql code.	Open/Save Create_hello_func.sql.
View Create_ins_sum_trig.sql code.	Open/Save Create_ins_sum_trig.sql.
View event_ts.sql code.	Open/Save event_ts.sql.
View show_events.sql code.	Open/Save show_events.sql.
View testref_trig.sql code.	Open/Save testref_trig.sql.

The code for testref_trig.sql is:
CREATE TABLE test1(a1 INT); CREATE TABLE test2(a2 INT); CREATE TABLE test3(a3 INT NOT NULL AUTO_INCREMENT PRIMARY KEY); CREATE TABLE test4( a4 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b4 INT DEFAULT 0 ); delimiter | CREATE TRIGGER testref BEFORE INSERT ON test1 FOR EACH ROW BEGIN INSERT INTO test2 SET a2 = NEW.a1; DELETE FROM test3 WHERE a3 = NEW.a1; UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1; END; | delimiter ; INSERT INTO test3 (a3) VALUES (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL), (NULL); INSERT INTO test4 (a4) VALUES (0), (0), (0), (0), (0), (0), (0), (0), (0), (0); # Test the triggers INSERT INTO test1 VALUES (1), (3), (1), (7), (1), (8), (4), (4); SHOW TRIGGERS; SHOW CREATE TRIGGER testref;