CREATE TRIGGER nombre BEFORE|AFTER INSERT|UPDATE|DELETE
	ON tabla FOR EACH ROW
	BEGIN  sentencias END

--------------------------------------------------------------------


CREATE EVENT nombre ON SCHEDULE  	schedule:
   				 	AT timestamp [+ INTERVAL interval] ...
  					| EVERY interval
    					[STARTS timestamp [+ INTERVAL interval] ...]
   					[ENDS timestamp [+ INTERVAL interval] ...]
[ON COMPLETION [NOT] PRESERVE]
DO event_body;

					interval:
   					quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
              				WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
              				DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}

EJ:
CREATE EVENT myevent
    ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
    DO
      UPDATE myschema.mytable SET mycol = mycol + 1;

SELECT @@global.event_scheduler; para ver si esta ON o OFF
SET @@global.event_scheduler = 1; poner ON la variable.

-----------------------------------------------------
CREATE TABLE nombretabla (
col_name type [NOT NULL | NULL] [DEFAULT default_value]
        [AUTO_INCREMENT] | [PRIMARY] KEY]
        [COMMENT 'string'],


PRIMARY KEY (index_col_name,...)
FOREIGN KEY  (index_col_name,...) [reference_definition]
)

REFERENCES tbl_name [(index_col_name,...)]
               [MATCH FULL | MATCH PARTIAL | MATCH SIMPLE]
               [ON DELETE reference_option]
               [ON UPDATE reference_option]


-----------------------------------------------------

DELIMITER $$

CREATE PROCEDURE build_email_list (INOUT email_list varchar(4000))
BEGIN

    DECLARE v_finished INTEGER DEFAULT 0;
        DECLARE v_email varchar(100) DEFAULT "";

    -- declare cursor for employee email
    DEClARE email_cursor CURSOR FOR
        SELECT email FROM employees;

    -- declare NOT FOUND handler
    DECLARE CONTINUE HANDLER
        FOR NOT FOUND SET v_finished = 1;

    OPEN email_cursor;

    get_email: LOOP

        FETCH email_cursor INTO v_email;

        IF v_finished = 1 THEN
            LEAVE get_email;
        END IF;

        -- build email list
        SET email_list = CONCAT(v_email,";",email_list);

    END LOOP get_email;

    CLOSE email_cursor;

END$$

DELIMITER ;