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_hello_func.sql is:
DROP FUNCTION IF EXISTS hello; CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN CONCAT('Hello, ',s,'!'); SELECT hello('world'); SELECT hello('students'); SHOW FUNCTION STATUS LIKE 'hello'; SHOW CREATE FUNCTION hello;