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 event_ts.sql is:
DROP TABLE IF EXISTS `test`.`store_ts`; CREATE TABLE `test`.`store_ts` ( `id` INT NOT NULL AUTO_INCREMENT, `time` DATETIME NOT NULL, PRIMARY KEY (`id`)); DROP EVENT IF EXISTS e_store_ts; CREATE EVENT e_store_ts ON SCHEDULE EVERY 10 SECOND DO INSERT INTO test.store_ts (time) VALUES (NOW()); #ALTER EVENT e_store_ts DISABLE; #ALTER EVENT e_store_ts ENABLE;