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 Create_dorepeat_proc.sql is:
DROP PROCEDURE IF EXISTS dorepeat; DELIMITER $$ CREATE PROCEDURE test.dorepeat(p1 INT) BEGIN SET @x = 0; REPEAT SET @x = @x + 1; UNTIL @x > p1 END REPEAT; END$$ DELIMITER ; CALL test.dorepeat(5); SELECT @x; CALL dorepeat(10); SELECT @x; SHOW CREATE PROCEDURE dorepeat;